Forum Discussion

Krijgersss's avatar
Krijgersss
Helper II
2 years ago
Solved

need help forming my data

i need some help with my data to get the right table structure my table looks like this right now  i want to have the rows complete like a complete table it has to look like this: Na...
Need Help
Show and Tell
  • AlienSx's avatar
    AlienSx
    2 years ago

    Krijgersss 

    let
    Source = your_table,
    cls = List.Buffer(List.Skip(Table.ToColumns(Source))),
    tbl = Table.FromColumns(
        List.Transform(cls, List.RemoveNulls),
        {"Name", "label", "number", "aangepast.1"}
    )
in
    tbl
AlienSx's avatar
AlienSx
Super User
2 years ago

Krijgersss 

let
    Source = your_table,
    cls = List.Buffer(List.Skip(Table.ToColumns(Source))),
    tbl = Table.FromColumns(
        List.Transform(cls, List.RemoveNulls),
        {"Name", "label", "number", "aangepast.1"}
    )
in
    tbl