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