SOLVED

Excel moving values from multiple columns into single column

%3CLINGO-SUB%20id%3D%22lingo-sub-3072769%22%20slang%3D%22en-US%22%3EExcel%20moving%20values%20from%20multiple%20columns%20into%20single%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3072769%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20table%20that%20displays%20the%20account%20executives%20of%20accounts.%20Currently%20Column%20A%20is%20the%20account%20number%20and%20the%20remaining%206%20columns%20are%20the%20account%20executive%20names.%20I%20would%20like%20to%20change%20this%20table%20into%20two%20columns%2C%20where%20column%20A%20is%20still%20the%20account%20numbers%20but%20duplicated%20for%20each%20account%20executive%2C%20and%20column%20B%20is%20the%20list%20of%20account%20executives.%20Is%20it%20possible%20to%20do%20so%20without%20much%20manual%20work%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3072769%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3072776%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20moving%20values%20from%20multiple%20columns%20into%20single%20column%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3072776%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1287743%22%20target%3D%22_blank%22%3E%40bur10012%3C%2FA%3E%26nbsp%3BConnect%20to%20the%20table%20with%20PowerQuery.%20Select%20the%20first%20column.%20Right-click%20and%20choose%20%22Unpivot%20Other%20Columns%22.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EClose%20and%20Load%20to%20a%20table.%20That's%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAre%20you%20familiar%20with%20PQ%3F%20If%20not%2C%20look%20in%20the%20attached%20link.%20Chapter%2013%20in%20particular.%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fexceloffthegrid.com%2Fpower-query-introduction%2F%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fexceloffthegrid.com%2Fpower-query-introduction%2F%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
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/