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:


Namelabelnumberaangepast.1
Roy BouwhuisJa8Hey Hey
Joery BerendsNee8Hoi Hoi
    
    
    

 

can somebody help me with this your help is appreciated!!!

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

1 Reply

  • 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