Transform columns without a qualitative column

[rohanraher]

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!

[Syk · Accepted solution]

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.