Forum Discussion

Krijgersss's avatar
Krijgersss
Helper II
2 years ago
Solved

Need help forming my data

hello i need some help with my data to get the right table structure. My data looks like this right now (see screenshot)

i want to have my data as a complete tabel like this:

submitted_atNaamLabelNummerOpmerking
16-01-2024 12:02:02Roy Bouwhuisja8Hoi Hoi
16-01-2024 12:01:11Joery Berendsnee8

Hey Hey

 

many thanks !!!!

Need Help
Show and Tell
Tips and Tricks
  • slorin's avatar
    slorin
    2 years ago

    Hi,

     

    Unpivot + Pivot

    let
      Source = Your_Source,
      Unpivot = Table.UnpivotOtherColumns(Source, {"submitted_at"}, "Attribute", "Value"),
      Pivot = Table.Pivot(Unpivot, List.Distinct(Unpivot[Attribute]), "Attribute", "Value")
    in
      Pivot

    Stéphane 

1 Reply

  • slorin's avatar
    slorin
    Super User
    2 years ago

    Hi,

     

    Unpivot + Pivot

    let
      Source = Your_Source,
      Unpivot = Table.UnpivotOtherColumns(Source, {"submitted_at"}, "Attribute", "Value"),
      Pivot = Table.Pivot(Unpivot, List.Distinct(Unpivot[Attribute]), "Attribute", "Value")
    in
      Pivot

    Stéphane