Forum Discussion
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 table into two columns, where column A is still the account numbers but duplicated for each account executive, and column B is the list of account executives. Is it possible to do so without much manual work?
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.
1 Reply
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.