Forum Discussion

michaelmland's avatar
michaelmland
New Member
3 years ago
Solved

Power Query - Create list from table, pulling column and row labels into new list

Good morning,

 

I am working on payroll files, and the data that comes out of our payroll software in a table format. I need to use the row and column labels to create a list, which I will convert to a Journal Entry. So effectively, I am attempting to generate a list from a table, where for each value in the table, the new list has a column for the row labels and the column labels (green goes to green, pink to pink, orange to orange, etc).

Hopefully this illustration shows what I want to do, and why I want Power Query to do it.

2 Replies

    • michaelmland's avatar
      michaelmland
      New Member

      Thank you for bringing this feature to my attention! I selected both of my row label columns, then used "Unpivot Other Columns" to get exactly what I need.