Transpose data, multiple columns and rows

[cubiclefarmer]

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!

 

[JEC]

If you are able to use Power Query you could just Unpivot other columns (1 click)

 

[cubiclefarmer]

If you are able to use Power Query you could just Unpivot other columns (1 click)

Hi JEC,
Thank you for your answer! I am very new with power query. I've got part of the way there now, but I still need all the data in Column C to be new headers in Row 1. I only need each of them once; each way I've been playing with it, power query keeps populating them far too many times. Did I do something wrong or is there another step here?

Thank you!

 

[cubiclefarmer]

So I actually stumbled into my answer this afternoon to get the data all transformed properly. Thank you so much!