Merging spreadsheet rows (partial duplicates) into new items

Questions
1

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
2

Hi @Pier-Andre_Maynard!

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

Thank you!

3

Hi @Ludwig , I sadly can’t share everything because it contains PII.

My current workflow is using the spreadsheet that is pre-filled with the merged records. I’m looking for a solution to handle that outside of excel.

Here is the excel format for the multiple sheets/groups I need to combine/merge IDs.

image
image1920×700 177 KB

I hope the resolution of the screenshot is high enough to understand the ask.
The ID column had matching values and I need to combine the values from the last columns when they match to a string with a comma.
I already have the quoting solved for in the workflow for the json API call to update users.

Thanks!

4

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.