How do I merge a split row back into it's original form?

[ComputerHabit]

I am trying to split a column into rows, do a join to another column for lookups and then put everything back.
Copilot gave me:

I've gotten to step 4 but I don't understand what is happening.

It's saying group the table.  I am a little confused on this because it's adding a new column, I think.

Also I'm a little confused by the let in statements and how I'm supposed to add them to my already applied steps.

[parry2k]

@ComputerHabit can you post the structure of the other table, and what column these two tables will use for the lookup. it would make life easier if you post the sample data from both the tables with the expected output. Getting partial input doesn't help much.

[ComputerHabit]

This is for a Sharepoint site.  I'm using the List connectors.

I have a people field that can contain multiple users.  The column shows as a List in Transforms.

I told it to extract the values.

now I can see the numbers.  I kind of know I could go straight to rows but I hadn't gone back.

Now that I have this column with each row containing a semicolon separate list of values I want to lookup the name of the 'person' related to the ID value.

[parry2k]

@ComputerHabit don't take me wrong, but what is the point of splitting at the first place 

[ComputerHabit]

I am lost as to how to replace these numbered values with their text counterpart in another table.

[ComputerHabit]

From another table... a  LOOKUP .. It's so hard in M Query to figure this out

[parry2k]

@ComputerHabit I'm not clear after you split it to the rows what you are looking for. More details will be helpful.

[ComputerHabit]

I have a column with list values.

I've expanded the column to show delimited values.

I split by row

Now I'm supposed to group.  But the button for Group just does SUMs and Counts which isn't what the instruction shows.  I'm trying to piece it together. 

I'm not used to the interface and what to do.

[ComputerHabit]

I give up on editing my last comment.  It gets messed up when tyring to edit.

I left out the merge with another table.

Now that it's merged I want to put it back to a comma separated values to undo the expansion of all the rows.

[parry2k]

@ComputerHabit not sure what you are trying to achieve but step 4 is taking the expanded table as a source, grouping it by id, and adding a new column that combines the textvalue column separated by a semicolon.

[ComputerHabit]

I'm trying to get the split rows back unsplit.  The data should go back to its orginal look.