Forum Discussion

gauravnarchal's avatar
gauravnarchal
Post Prodigy
4 years ago
Solved

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....
  • Pragati11's avatar
    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.