Transform Table Vertically

[Fernando_Elecno]

Hello guys!
How can i to do this...

CODE	TOTAL "A"	TOTAL "B"	TOTAL "C"
LT01	5	-1	0
LT02	4	-2	0
LT03	3	-3	0
LT04	2	-4	0

in this?

CODE	COLUMN	TOTAL
LT01	TOTAL "A"	5
LT02	TOTAL "A"	4
LT03	TOTAL "A"	3
LT04	TOTAL "A"	2
LT01	TOTAL "B"	-1
LT02	TOTAL "B"	-2
LT03	TOTAL "B"	-3
LT04	TOTAL "B"	-4
LT01	TOTAL "C"	0
LT02	TOTAL "C"	0
LT03	TOTAL "C"	0
LT04	TOTAL "C"	0

Thanks a lot!

[amitchandak · Accepted solution]

@Fernando_Elecno ,Refer : https://radacad.com/pivot-and-unpivot-with-power-bi

[Greg_Deckler]

Right-click your CODE column in Power Query and choose Unpivot other columns.