transpose data

[matteog]

Hello,

I have the following table:

col.A	col.B	col.C
item1	x	y
item2	z	w

I'd like to transpose as following

col.A	Col.b
item1	x
item1	y
item2	z
item2	w

Is it possible to do it in PowerBI in an easy and fast way? In my final table I have a lot of rows and columns.

Thanks

[amitchandak · Accepted solution]

@matteog , refer if these can help

Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/

https://radacad.com/pivot-and-unpivot-with-power-bi