Merging spreadsheet rows (partial duplicates) into new items

Describe the problem/error/question

Hi, I am trying to achieve the equivalent of this (done 100% in excel) in n8n so I can use that same data into subsequent calls/nodes.
https://answers.microsoft.com/en-us/msoffice/forum/all/how-to-combine-duplicate-rows-into-one-keeping/8c3e83dd-7667-4f13-9495-15ac5b58043e
I tried different nodes to do this without much success. (Merge, Summarize, remove duplicates)

I have a node that reads multiple files, then pass on to the spreadsheet node before this so I have rows with matches in some columns and different values that I want to concatenate into a single column/item separated by a comma.

Information on your n8n setup

  • n8n version: 1.34.2
  • Database (default: SQLite):
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): npm
  • Operating system: M1 Mac

Hi @Pier-Andre_Maynard!

Can you share your workflow, with some example data for testing?

Thank you!