Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

Transform Data from rows to columns

Hi,    is it possible to transfrom some table from these structure: ID          Attribute 4711      A 4711      B 4712      A   in the following result: ID       Attribute 4711   A|B 4712 ...
Need Help
  • slorin's avatar
    slorin
    1 year ago

    Hi Anonymous 

    Group by ID, choose Sum and replace List.Sum by Text.Combine(  , "|")

    = Table.Group(Source, {"ID"}, {{"Attribute", each Text.Combine([Attribute], "|"), type text}})

     

     

    Stéphane 

slorin's avatar
slorin
Super User
1 year ago

Hi Anonymous 

Group by ID, choose Sum and replace List.Sum by Text.Combine(  , "|")

= Table.Group(Source, {"ID"}, {{"Attribute", each Text.Combine([Attribute], "|"), type text}})

 

 

Stéphane