How to transpose

[uwish7]

I have data that is material description July Aug Sept. The forecast is below each month. I will like the format to be
Mat Des Jan Forecast
Mat Des Feb Forecast

Essentially, I will like to transpose the months and Forecast. I hve 80 unique material numbers.

What is the quickest way of getting this done? I think a Macro or VBA but I am not skilled in this operation

 

[alansidman]

If you are using Excel 2010 or later, this can be easily accomplished using Power Query/Get and Transform.

 

[Seba Robles]

If I understand correctly you want to convert cross-tab data into a list? As to "unpivot" the data?

If so, you can use this 3min video

https://www.youtube.com/watch?v=pUXJLzqlEPk