Need help forming my data

[Krijgersss]

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_at	Naam	Label	Nummer	Opmerking
16-01-2024 12:02:02	Roy Bouwhuis	ja	8	Hoi Hoi
16-01-2024 12:01:11	Joery Berends	nee	8	Hey Hey

many thanks !!!!

[slorin · Accepted solution]

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