Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
cottrera
Post Prodigy
Post Prodigy

Transpose Help

Hi I have the following table

Unit ReferenceProperty AttributeFinal Cost
21428BATHROOM2493
21428FENCE-REAR597.1
21428BOUNDARY1869.6
21428BRICKWORK80
21428EXTDOOR21000
21428CHIMNEY2450
21428FENCE-FRNT344.75
21428COOKER0
21428DEC-EXT4432
21428EXTDOORS1200
21428ELECTRICAL300
21428F-FREEZER0
21428GATE120
21428HEATING3250
21428KITCHEN5879
21428LAND0
21428PATHWAYS8114.4
21428ROOFS13746
21428SMOKE255
21428SOFFITS1499.5
21428WINDOWS525
21428GARAGE3112
21428WFINISH2980.5
21428WSTRUCTURE90

 

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

 

Unit ReferenceBATHROOMFENCE-REARBOUNDARYBRICKWORKEXTDOOR2CHIMNEYFENCE-FRNTCOOKERDEC-EXTEXTDOORSELECTRICALF-FREEZERGATEHEATINGKITCHENLANDPATHWAYSROOFSSMOKESOFFITSWINDOWSGARAGEWFINISHWSTRUCTURE
214282493597.11869.68010002450344.7504432120030001203250587908114.4137462551499.552531122980.590

 

 

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

 

thank you

 

Richard

1 ACCEPTED SOLUTION
serpiva64
Solution Sage
Solution Sage

Hi,

You have to pivot your column Property attribute this way

serpiva64_0-1668684104402.png

and you get your result

serpiva64_1-1668684195444.png

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 !

 

View solution in original post

2 REPLIES 2
cottrera
Post Prodigy
Post Prodigy

Great thnk you for your quick response 😀

serpiva64
Solution Sage
Solution Sage

Hi,

You have to pivot your column Property attribute this way

serpiva64_0-1668684104402.png

and you get your result

serpiva64_1-1668684195444.png

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 !

 

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

Top Solution Authors
Top Kudoed Authors