Forum Discussion

maxs3's avatar
maxs3
Frequent Visitor
4 years ago
Solved

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: Lot Part Measurement Value 1 1 A ...
  • jsaunders_zero9's avatar
    4 years ago

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

     

     

    End state