Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Combine rows (based on ID) into single row with multiple columns

Dear all, How can I combine multiple rows into single row with multiple columns as below?   Regards,   Urmas 
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    You can first Group By Id, making sure you select "All Rows" as the Aggregation. Name the column "NewRows". Then you can do this:

     

    = Table.TransformColumns(#"Grouped By",  {{"NewRows", each Table.FromRows(List.Combine(Table.ToRows(_)))}})

     

    Then delete the other columns and expand the tables.

     

    --Nate

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

You can first Group By Id, making sure you select "All Rows" as the Aggregation. Name the column "NewRows". Then you can do this:

 

= Table.TransformColumns(#"Grouped By",  {{"NewRows", each Table.FromRows(List.Combine(Table.ToRows(_)))}})

 

Then delete the other columns and expand the tables.

 

--Nate

 

Anonymous's avatar
Anonymous
Not applicable
4 years ago

IT works. perfectly. I only had to add curly brackets in one place in the end:

= Table.TransformColumns(#"Grouped Rows", {{"NewRows", each Table.FromRows({List.Combine(Table.ToRows(_))})}})

 

Thank you very much,

 

Urmas