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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
maxs3
Frequent Visitor

Turn strings within rows into columns with data from another column (pivot?)

Hello,

 

I cannot figure out how to perform the below operation, I believe it is either pivot, or group, but cannot seem to find it.

 

Inital table:

LotPartMeasurementValue
11A54
11B65
12A74
12C54
21A31
21B15
23A45
23D34

 

 

Final Desired table:

LotPartABCD
115465  
1274 54 
213115  
2345  34
1 ACCEPTED SOLUTION
jsaunders_zero9
Responsive Resident
Responsive Resident

To do this in Power Query select columns "Measurement" and "Value", go to transform toolbar and select pivot columns.

 

jsaunders_zero9_0-1661387379167.png

 

End state

jsaunders_zero9_1-1661387419331.png

 

 

View solution in original post

1 REPLY 1
jsaunders_zero9
Responsive Resident
Responsive Resident

To do this in Power Query select columns "Measurement" and "Value", go to transform toolbar and select pivot columns.

 

jsaunders_zero9_0-1661387379167.png

 

End state

jsaunders_zero9_1-1661387419331.png

 

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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