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

 

PowerBIPuffGirl's avatar
PowerBIPuffGirl
Regular Visitor
4 years ago

In the solution, where do you type this:

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

I'm very new to Power BI, so appreciate the help!