Grouping Rows and Still Showing Multiple Non-Grouped Cells

Hi jamiers ,

Here's my final outcome.

And below are my steps.

1.Group by account_id and add a column to keep all rows.

2.Add an index column.

3.Add a column contains All MC Pos values.

4.Extract values from list as follows.

5.Expand the "AddIndexColumn", you will get the following. Filter out the Index 2 to get the final outcome.

Reference:

How to merge different rows with the same attribut... - Microsoft Fabric Community

Best Regards,

Stephen Tao

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