Home

how to transpose multiple column into one column?

Ishu Mehta
Occasional Visitor

how to transpose multiple column into one column?

Can anybody help me to achieve this ?

 

existing table   
     
productredgreen yellowblue
chair10203040
table50607080

 

required table  
    
productcolorprice 
chairred10 
chairgreen 20 
chairyellow30 
chairblue40 
tablered50 
tablegreen 60 
tableyellow70 
tableblue80 

 

No Macros please

2 Replies

Re: how to transpose multiple column into one column?

Hello Ishu Load the table in Power Query and unpivot the four rightmost columns. Change the column headers. Done.
Highlighted

Re: how to transpose multiple column into one column?

Quick Video lesson on how to do this with Power Query:

 

Related Conversations
How can I delete Teams free organization?
Kazuaki Tauchi in Microsoft Teams on
5 Replies
Auto-Add new employees
Mathias Koprek in Microsoft Teams on
9 Replies
Linking OneDrive to New Microsoft Teams Channel
Anonymous in Microsoft Teams on
7 Replies