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.