Forum Discussion
michaelmland
3 years agoNew Member
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
- DominoPBIFrequent Visitor
- michaelmlandNew 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.