cubiclefarmer
New Member
- Joined
- Jan 4, 2024
- Messages
- 3
- Office Version
- 365
- Platform
- Windows
Hello,
I have a fairly large dataset I need to transpose and I'm not sure how to get the result I want easily. The screenshots below are my example data I'm playing with before I try anything on the real spreadsheet.
The first image is how the data comes to me and the second is how I need it all to end up for all of the categories. I'm a newbie when it comes to VBA or Power Query. Everything I know how to do in excel is self taught so any help is appreciated.
I'm new to this forum so if I need to post somewhere else or didn't tag something right, please let me know.
Thank you!
I have a fairly large dataset I need to transpose and I'm not sure how to get the result I want easily. The screenshots below are my example data I'm playing with before I try anything on the real spreadsheet.
The first image is how the data comes to me and the second is how I need it all to end up for all of the categories. I'm a newbie when it comes to VBA or Power Query. Everything I know how to do in excel is self taught so any help is appreciated.
I'm new to this forum so if I need to post somewhere else or didn't tag something right, please let me know.
Thank you!