April 20, 2020
I get a file from a data repository and it is not organized such a way I can "pivot table" it the way I need.
It have as many columns as years and the countries are in one column --> I receive a 64 X 265 table.
I want to transpose the data in order to get a 3 columns based table : countries, years and values such a way I will be able to plot the data with pivot table to get the values in an y-axis and the date frame in the x-axis per countries. (Columns B, C and D should follow the transposition if possible if not, we can delete them).
How can I perform that transposition in excel ? xlsx file is attached.
July 16, 2010
This is a job for Power Query, so I've moved your topic and edited the subject accordingly. You can use Power Query's Unpivot tool to fix the layout of columns E through BL. Note: you should select columns A:D and then 'Unpivot Other Columns'.