Combining similar rows

[M_Capps]

Hello,

I'm working in Power BI and trying to combine similar rows while putting the differences in the same cell.

Here's an example of my current data:

File #	Assigned Staff	Project Name
1	John Doe	Space March
1	Jane Smith	Space March
2	Dave Williams	File Sharing

Here's what I'm aiming to do:

File #	Assigned Staff	Project Name
1	John Doe/Jane Smith	Space March
2	Dave Williams	File Sharing

[M_Capps]

That worked brilliantly. Thanks.

[DataNinja777 · Accepted solution]

Hi @M_Capps ,

To combine similar rows in Power BI where the File # and Project Name are the same, and you want to merge the Assigned Staff values into a single cell separated by a slash, you can do this in Power Query. First, go to the Power Query Editor. Use the Group By feature, grouping by both File # and Project Name. For the operation, select "All Rows" so that you can access the individual rows grouped together. Then, add a custom column that merges the Assigned Staff values using Text.Combine.

Here's the custom column formula you can use:

Text.Combine([Assigned Staff], "/")

After that, remove the original nested Assigned Staff column and keep the new column with combined values. This will give you the desired output where names are joined like John Doe/Jane Smith under a single row for the same file and project.

Best regards,