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? 

1 Reply
best response confirmed by bur10012 (Microsoft)

@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.