Forum Discussion
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_at ...
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
PivotStéphane
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