Forum Discussion
Converting repeating rows into columns
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 O...
Anonymous , Try pivot
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/
Anonymous , Try pivot
https://radacad.com/pivot-and-unpivot-with-power-bi
Transpose : https://yodalearning.com/tutorials/power-query-helps-transposing-data/
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