Multiple People in single row from SharePoint list

Hi, PBI8423 

You can use this function to concatenate the values of a column into a single text string with a specified delimiter.

After you expand the SharePoint list in Power Query, select the column that contains the person's name. Go to the tab and click . In the window, select the drop-down list. Add a new step with the click of a button.

In the formula bar, type the following formula, and then press Enter:

= Table.AddColumn(#"Grouped Rows", "People", each Text.Combine([Column1][People], "; "))

Replace with the name of the previous step and replace with the name of the column. This will create a new column where the names are combined and separated by semicolons

You can check the following links:

Text.Combine - PowerQuery M | Microsoft Learn

Or use the "Group by" feature directly, and the related documentation is below

How to GROUP BY or summarize rows - Power Query | Microsoft Learn

How to Get Your Question Answered Quickly 

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.