Forum Discussion
aktripathi2506
Helper IV
Helper IVReplacing columns with rows
Hi, In my table suppose I have 5 column A, B, C, D and E. I have values for them. Example: A B C D E 5 22 15 32 4 10 4 8 25 9 11 9 6 4 4 21 4 8 12 11 ...
In Power BI Desktop, you can directly use your large input table and return the average of each item without exporting the data at all. Please refer to steps below:
- Add an Index column(from 1).
- Right click on Index column, select "Unpivot other columns".
- Click on "Attribute" column, select "Group By".
- Set "Group by" like below. You will get expect result.
Regards,
- Add an Index column(from 1).
