Converting repeating rows into columns

[Anonymous]

I have a table which looks like this - (just giving an example and this repeats for multiple times)

A.1	Order no	123
A.2	Product	Laptop
A.3	Revenue	135
A.4	Margin	25
A.1	Order no	234
A.2	Product	Server
A.3	Revenue	200
A.4	Margin	25
A.1	Order no	456
A.2	Product	Laptop
A.3	Revenue	135
A.4	Margin	2

I would like it to be transformed into this - 

A.1	A.2	A.3	A.4
Order no	Product	Revenue	Margin
123	Laptop	135	25
234	Server	200	25
456	Laptop	135	2

Can you help me with the steps to achieve this while I am transforming data? 

[dannytan111289]

Hi,

Did you have any answer to your case? if you have the solution, do u mind to put it here? Thanks

[amitchandak · Accepted solution]

@Anonymous , Try pivot

https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/

[dannytan111289]

Hi,

I don't really understand the link that you gave. If we do transpose directly, the result would be 12 columns of A1-A4 repeatedly. Any idea how to make it became 4 columns and multiple rows ? Because i have the same problem. Thanks sir