Forum Discussion

jamiers's avatar
jamiers
Helper I
3 years ago
Solved

Grouping Rows and Still Showing Multiple Non-Grouped Cells

OK -- I have something screwy going on and it is just because of lack of knowledge - plain and simple.  I have the following line:     Table.Group(#"Buffer Table", {"account_id","Name (link)","Me...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    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.           

ToddChitt's avatar
ToddChitt
Super User
3 years ago

So if I understand you correclty, in your result set, you want ONE row for ID 43222(Adams, John) and a column that combines TWO rows of data into one cell, separated by a carriage return.

Not for nothing, but how did you decide that column E should be "New London"?