PowerQuery Unpivot Table

[chall069]

I am trying to unpivot data in power query. The data comes in this format. I am not able to fisgure out the best way to create the second table.

	PI20.2	PI20.2	PI20.2	PI20.2	PI20.2	PI20.2	PI20.3	PI20.3	PI20.3	PI20.3	PI20.3	PI20.3
Team	Committed	Completed	%	Progressed	Velocity	BUG Effort	Committed	Completed	%	Progressed	Velocity	BUG Effort
Team A	70	60	70.00%	17	60	34	60	60	70.00%	0	60	34
Team B	70	60	70.00%	17	60	34	60	60	70.00%	0	60	34
Team C	70	60	70.00%	17	60	34	60	60	70.00%	0	60	34
Team D	70	60	70.00%	17	60	34	60	60	70.00%	0	60	34
Team E	70	60	70.00%	17	60	34	60	60	70.00%	0	60	34
Team F	70	60	70.00%	17	60	34	60	60	70.00%	0	60	34

I would like to transform it into this format. Is there any way to accomplish this?

Team	PI	Attribute	Value
Team A	PI20.2	Committed	60
Team B	PI20.2	Completed	60
Team C	PI20.2	%	70
Team D	PI20.2	Progressed	60
Team E	PI20.2	Velocity	50
Team F	PI20.2	BUG Effort	50
Team A	PI20.3	Committed	60
Team B	PI20.3	Completed	60
Team C	PI20.3	%	70
Team D	PI20.3	Progressed	60
Team E	PI20.3	Velocity	50
Team F	PI20.3	BUG Effort	50

[Ahmedx · Accepted solution]

Based on your description, I created data to reproduce your scenario. The pbix file is attached in the end.

[chall069]

Thank you very much. This work!