how to transpose multiple column into one column?

Question

Can anybody help me to achieve this ?&nbsp;existing table&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;productredgreen&nbsp;yellowbluechair10203040table50607080&nbsp;required table&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;productcolorprice&nbsp;chairred10&nbsp;chairgreen&nbsp;20&nbsp;chairyellow30&nbsp;chairblue40&nbsp;tablered50&nbsp;tablegreen&nbsp;60&nbsp;tableyellow70&nbsp;tableblue80&nbsp;&nbsp;No Macros please

ingeborghawighorst · Answer

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

detlef_lewin · Answer

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

Forum Discussion

how to transpose multiple column into one column?

Share

Resources

existing table

product	red	green	yellow	blue
chair	10	20	30	40
table	50	60	70	80

required table

product	color	price
chair	red	10
chair	green	20
chair	yellow	30
chair	blue	40
table	red	50
table	green	60
table	yellow	70
table	blue	80