Forum Discussion
gauravnarchal
4 years agoPost Prodigy
Rearrange data table
Hello How can I arrange my data from Description 22205 835 803 80104 NI POS SETT 260222 200000812- 9806.23 233.12 11.65 -10051.00 9806.23 NI POS SETT 270222 200000812- 10171....
- 4 years ago
Hi gauravnarchal ,
You can achive this simple in Power Query Editor in Power BI Desktop, by following the steps below:
This is the source data that you shared:
Now select your Description column --> under Transform --> select Unpivot Columns --> Unpivot other columns as shown below:
Onec you do this transformation, you will get the following:
This is nearly the required result you need.
Rename Attribute to Account and Value to Amount column names by right-clicking on the respective columns. This will give you the following:
Now just hold the Description column and drag it to the right, to get the expected output:
This is the desired result. Hope this helps.
Datavizuserpbi
4 years agoHelper I
Hello,
Make a transposition of your table and your column gonna become row .
!!