Transpose Help

[cottrera]

Hi I have the following table

Unit Reference	Property Attribute	Final Cost
21428	BATHROOM	2493
21428	FENCE-REAR	597.1
21428	BOUNDARY	1869.6
21428	BRICKWORK	80
21428	EXTDOOR2	1000
21428	CHIMNEY	2450
21428	FENCE-FRNT	344.75
21428	COOKER	0
21428	DEC-EXT	4432
21428	EXTDOORS	1200
21428	ELECTRICAL	300
21428	F-FREEZER	0
21428	GATE	120
21428	HEATING	3250
21428	KITCHEN	5879
21428	LAND	0
21428	PATHWAYS	8114.4
21428	ROOFS	13746
21428	SMOKE	255
21428	SOFFITS	1499.5
21428	WINDOWS	525
21428	GARAGE	3112
21428	WFINISH	2980.5
21428	WSTRUCTURE	90

In power query I would like to transpose it to look like this with the unit reference in the first column

Unit Reference	BATHROOM	FENCE-REAR	BOUNDARY	BRICKWORK	EXTDOOR2	CHIMNEY	FENCE-FRNT	COOKER	DEC-EXT	EXTDOORS	ELECTRICAL	F-FREEZER	GATE	HEATING	KITCHEN	LAND	PATHWAYS	ROOFS	SMOKE	SOFFITS	WINDOWS	GARAGE	WFINISH	WSTRUCTURE
21428	2493	597.1	1869.6	80	1000	2450	344.75	0	4432	1200	300	0	120	3250	5879	0	8114.4	13746	255	1499.5	525	3112	2980.5	90

The exampl below is for one unit there will be many untit references.

thank you

Richard

[cottrera]

Great thnk you for your quick response 😀

[serpiva64 · Accepted solution]

Hi,

You have to pivot your column Property attribute this way

and you get your result

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !