How to combine duplicate rows in Excel

I'm trying to identify Parent and Child records for import to a relational database. Where a duplicate set is found, the first row will be designated as the "parent", and any duplicates to that should get a reference to the group's parent row.

The format is -
id|name|address|...|parentid

For each group of duplicates, the value in the "id" column should be written to the "parentid" column.

Been spending so long trying to get this to work using python, excel, bedtools... finally a light at the end of the tunnel, thank you so much, this is extremely useful for genomic work

with the help of add-on tools i have merged the duplicates in my sheet perfectly and it's great!
My concern is that, I am entering new data to the same sheet and is there any way to automatically merge a duplicate data to the previously merged row in the primary column?

For example, if i am sorting names with same addresses and if i entered another name with a merged address, how to merge that data with the previous data automatically?
Need an answer ASAP.

Thank you.

Hi, do you have this tool working for Excel for Mac Version 15.33 ?

Thank you!

Do the "key columns" function as an "and" statement? Say I have 3 columns A, B, and C. If I choose A & B as the key columns, will it only merge the cells that are duplicates in BOTH columns A & B? Or will it merge the cells that are duplicates in EITHER column A & B?

I am trying to combine rows or use Merge to merge rows, but it is putting spaces in the columns with different text....not creating separate column for the data.
Other ID Sibling 1 Other ID Cur School Code Grade 1
316753 425854 043 07
316753 376197 005 12
317307 455642 129 04
317307 437647 051 08

I want all of data associated with other ID to be on one row, different columns. I could do this with combine rows.
Merge make you select delimiter and I don't want a delimiter.

Hello,

I used the Delete Duplicate Wizard to remove duplicated rows in a single sheet and used the =MAX() delineator. Howver I'm running into a Database issue when importing the result. Instead of importing the result of =MAX() it is importing the entire equation =MAX(32,0). Is there a way for the tool to just leave the result behind and not the formula?

Thanks,
Dan
P.S. This is hands-down the best add-on I've ever needed and used.

Holy cannoli, this feature alone was worth the price of the tool.

Is it possible to work these into VBA routines? I tried recording a macro with this, but it didn't work. (Very annoying when you need to run this on a template with 3 key columns, sum a fourth, and comma-delimit the fifth... repeated across several dozen spreadsheets per week!)

I am using Office 365 and once I combine the sheets and then merge duplicates; I have the delimiter appear in most of the cells when there is no duplicate. Below is an example of 2 columns that should not have the delimiter after the information:

Street2 City
n/a, Huntersville,
n/a, Winston Salem,
n/a, Pickens,
n/a, Randleman,
n/a, Mooresville,
n/a Raeford
n/a, Lumberton,
n/a Robbins
n/a, Statesville,
n/a, Kannapolis,
n/a Fayetteville

Hey There,

I merged a table in excel with duplicate values, once I updated my source table with new values and hit refresh the duplicate values start showing up again.

Could you please help me with this issue.

Regards,

Arsalan Qureshi

I am floored by how much is in this tool and am so excited to use this for a lot of excel projects!

I am trying to currently merge rows with duplicate data in Column H, but also override data from Columns B-G rather than put it in one cell with delimiters. Column A will be the determiner as to which data in B-G to override. For example, my first argument is to merge duplicate data identified in H, second argument is to override any data in B-G (unless null) if column A =NEW.

My long answer is probably use the delimiter, then run an if function to remove data from those cells...I was hoping there would be a simpler option. I hope this makes sense - I also emailed support but it is the weekend and I'm hoping for a quick answer.

Is there an option to not merge the values into a single cell, but rather to use a new cell (column) for subsequent values? I can always use a character that isn't in my data set and then use text to columns to achieve the result, but that assumes that one of the available delimiters isn't in use.

Hi ,

I downloaded the ultimate suite, but am not able to find the "Combine Rows" functionality.

I can't chose delimiter [Line break]. How to chose it ?Pls help me !

Just find this amazing function, saved me for hours of work
OK, it didn't removed all duplicate value, some "," before and after was not removed, but all together saved me for lot's of work

Tom

I am having an issue when I try to sum decimal numbers. When I merge the cell with decimal numbers it makes the formula looks like two numbers in a cell (ex. cells 2,4 and 3,4 appears as sum(2;4;3;4) )
Obs. I am from Brasil and here we use comma as separator of decimal numbers.