Forum Discussion
Transposing a table
Hello, I have a panel data table. The value of an item is recorded each year. The column has values corresponding to the year ( table 1). So, there are 11 years and 11 different columns. I want to ...
As Mr. Wyn Hopkins said, Power Query is the most suitable tool for this.
Here is some information and help for the first steps from Microsoft.
Combine data from multiple data sources (Power Query)
* Knowing the Excel version and operating system would also be an advantage.
I would be happy to know if I could help.
Nikolino
I know I don't know anything (Socrates)