Forum Discussion

russell80's avatar
russell80
Helper III
3 years ago
Solved

Help Unpivoting/Pivoting a Table

I have a table with the following structure: ID Action1 Action2 Action3 Action1DueDate Action2DueDate Action3DueDate Action1Completed Action2Completed Action3Completed 1 a b c 01/...
Need Help
  • slorin's avatar
    slorin
    3 years ago

    Hi,

     

    let
    Source = YourSource,
    Unpivot = Table.UnpivotOtherColumns(Source, {"ID"}, "Attribute", "Value"),
    Group = Table.Group(Unpivot, {"ID"}, {{"Data", each Table.FromColumns(List.Split([Value],3), {"Action", "DueDate", "Completed"})}}),
    Expand = Table.ExpandTableColumn(Group, "Data", {"Action", "DueDate", "Completed"}, {"Action", "DueDate", "Completed"})
    in
    Expand

    Stéphane 

russell80's avatar
russell80
Helper III
3 years ago

Thanks, that works perfectly!