Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Pivoting Data

Hi all, I have the below problem. I would like to pivot my data from 

to

 

Need Help
  • AlienSx's avatar
    AlienSx
    2 years ago
        one = Table.ToList(
        your_table, 
        (w) => List.TransformMany(
            {w}, 
            (x) => List.Skip(List.Split(x, 2)),
            (x, y) => List.FirstN(x, 2) & y
        )
    ),
    two = Table.FromList(List.Combine(one), (x) => x, {"Name", "Phone", "Address", "State"})

1 Reply

  • AlienSx's avatar
    AlienSx
    Super User
    2 years ago
        one = Table.ToList(
        your_table, 
        (w) => List.TransformMany(
            {w}, 
            (x) => List.Skip(List.Split(x, 2)),
            (x, y) => List.FirstN(x, 2) & y
        )
    ),
    two = Table.FromList(List.Combine(one), (x) => x, {"Name", "Phone", "Address", "State"})