Forum Discussion
Solved
Excel moving values from multiple columns into single column
I have a table that displays the account executives of accounts. Currently Column A is the account number and the remaining 6 columns are the account executive names. I would like to change this tabl...
bur10012 Connect to the table with PowerQuery. Select the first column. Right-click and choose "Unpivot Other Columns".
Close and Load to a table. That's it.
Are you familiar with PQ? If not, look in the attached link. Chapter 13 in particular.
bur10012 Connect to the table with PowerQuery. Select the first column. Right-click and choose "Unpivot Other Columns".
Close and Load to a table. That's it.
Are you familiar with PQ? If not, look in the attached link. Chapter 13 in particular.