Forum Discussion
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.66 | 234.60 | 11.74 | -10418.00 | 10171.66 |
to below
| Account | Description | Amount |
| 22205 | NI POS SETT 260222 200000812- 9806.23 | 233.12 |
| 835 | NI POS SETT 260222 200000812- 9806.23 | 11.65 |
| 803 | NI POS SETT 260222 200000812- 9806.23 | -10051.00 |
| 80104 | NI POS SETT 260222 200000812- 9806.23 | 9806.23 |
| 22205 | NI POS SETT 270222 200000812- 10171.66 | 234.60 |
| 835 | NI POS SETT 270222 200000812- 10171.66 | 11.74 |
| 803 | NI POS SETT 270222 200000812- 10171.66 | -10418.00 |
| 80104 | NI POS SETT 270222 200000812- 10171.66 | 10171.66 |
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.
7 Replies
Hello,
Make a transposition of your table and your column gonna become row .
!!
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.
Pragati11 - Brilliant - Thank you for your help...
HI gauravnarchal ,
If the solution helped, appreciate a kudos and do accept it as a solution to this thread so that others can benefit from it on the forum.
