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

[michaelmland]

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.

[DominoPBI · Accepted solution]

Hi @michaelmland 

Did you try to use unpivot columns?

[michaelmland]

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.