Forum Discussion
Transform columns without a qualitative column
Hi community,
I am trying to transform a table using Power Query but not able to achieve the desired result. I am posting an example of the data set below for referral, can anyone please help me out?
Current structure -
| FY 23 Backlog A | FY 23 Revenue A | FY 23 Pipeline A | Business A Total | FY 23 Backlog B | FY 23 Revenue B | FY 23 Pipeline B | Business B Total |
| 1000 | 2000 | 3000 | 6000 | 100 | 200 | 300 | 600 |
Required structure -
| Business (Only Business Name from the table) | Revenue Type | Value |
| A | Backlog | 1000 |
| A | Revenue | 2000 |
| A | Pipeline | 3000 |
| B | Backlog | 100 |
| B | Revenue | 200 |
| B | Pipeline | 300 |
Many thanks!
Select all your columns and under transform, unpivot columns.
Then in your new attribute column, filter out all the rows that contain "Total". Then you can split the attribute column to get your remaining info such as a business name column and so on.
1 Reply
Select all your columns and under transform, unpivot columns.
Then in your new attribute column, filter out all the rows that contain "Total". Then you can split the attribute column to get your remaining info such as a business name column and so on.