Forum Discussion
Rearrange data table
- 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.
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...
- Pragati114 years agoSuper User
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.
- Pragati114 years agoSuper User
HI gauravnarchal ,
Can you please mark the right solution to this thread rather than your response please?
- gauravnarchal4 years agoPost Prodigy
Hi Pragati11 - Done 🙂
- Pragati114 years agoSuper User