Forum Discussion
Solved
Transforming rows and columns to a sequence of rows
I have a largely empty spreadsheet that looks something like this: Col1Label Col2Label Col3Label ... Row1Label Row2Label Row3Label Row4Label ... I want to transform it in...
Hello,
Power Query can be used for that. First, copy all column labels into all rows, like this:
Then load the table into Power Query (called Get&Transform) in Excel 2016. Select Column 1 and then click Unpivot other columns. Combine the two columns you want to keep and delete the rest. The result looks like this:
Ingeborg,
Worked perfectly. Thanks a lot!
Worked perfectly. Thanks a lot!