SOLVED

Excel moving values from multiple columns into single column

Microsoft

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)
Solution

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

https://exceloffthegrid.com/power-query-introduction/ 

1 best response

Accepted Solutions
best response confirmed by bur10012 (Microsoft)
Solution

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

https://exceloffthegrid.com/power-query-introduction/ 

View solution in original post