Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!

Subscribe for Free Excel tips & more!

Free Excel Forum

Merge/combine/overlay But Dont Duplicate???

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

View Answers     

Similar Excel Tutorials

Prevent Duplicate Values in Excel
I show you how to prevent duplicate values being entered into Excel using Data Validation. Let's say we have a lis ...
Join a Date and Time into a Single Cell using VBA Macros in Excel
In order to combine a cell that has a date with a cell that has a time, using a Macro and VBA in Excel, you must su ...
How to Arrange Data within Cells in Excel
In this tutorial I am going to look at cell alignment / arrangement. These features allow you to change how data lo ...
MODE() - Find Most Repeated Value in a List in Excel
The MODE() function in Excel allows you to quickly find the most repeated or frequently occuring value within a lis ...

Helpful Excel Macros

Combine Multiple Workbooks into One
- This macro for Microsoft Excel allows you to combine multiple workbooks and worksheets into one new workbook and workshe
Delete Duplicate Rows
- This macro will delete rows that appear twice in a list or worksheet. If two cells are identical, this macro will delete
Open any Program from Excel
- This free excel macro allows you to open any program on your computer from excel. You can open a media player, file vie

Similar Topics

Hello, I have a spreadsheet in which I would like to merge duplicate rows and combine data into one cell in the row. I have attached an example of what I have and what I want the end result to be. I don't know if there is a macro, etc. to do this, but any assistance would be greatly appreciated! Thank you.

Im trying out MrExcels Easy-XL and for the life of me, Im having a heck of a time getting my head wrapped around a simple function like MERGE

I have a list of products that somehow got copied a few times and various work was done on each of the 4 copies! Now what I need to do is combine them based on the (product number) and simply append all the data.

Some sheets might have for example part of the dept or sub catagories done, whereas another sheet might have the Mfgrs all updated, another might have the Vendors we buy them from updated ..

and what I have to do is just put them all together.

Given the 4 "MERGE OPTIONS" available (to output rows with the types of matches) ... for some reason Im just getting totally goofed!

1 Rows in sheet 1 that match a row in sheet 2
2. Rows in sheet 1 that DONT match a row in sheet2, (columns combine from sheet 2 will be blank)
3 Rows in sheet 2 that match a row in sheet 1
4. Rows in sheet 2 that DONT match a row in sheet1, (columns combine from sheet 1 will be blank)

I just need the idiotproof version / way of doing this ...
I was just hoping to Merge!

Sorry .. I know in a week, Ill look back at this and be totally ashamed of myself!


Having an issue where I am trying to use mail merge in congress with an Excel spreadsheet. The spreadsheet in question has a data dump from the database and lists mutiple rows of contact information. However some of the contacts have multiple Job descriptions, hence there are duplicate rows for some of these people. I am trying to find a way to combine the data from the multiple rows of these duplicates into one row so that mail merge will pull the data from it correctly. If that was as confusing as it feels, let me try an example.

In the attached spreadsheet example, I need mail merge to pull from one row, all of Mr. Pink's information. You will notice that he exists in the list three times, because the industry column is unique for each row. What I would like to do is somehow combine this information into a single row for Mr. Pink, and as many others as are represented in the data dump, so that mail merge will work.

Many thanks for any assistance,

how would i run a macro to merge duplicate cells in a column

For example, i have lots of data in columns A, B and C
however some of the data in columns A and B is the same. Column C data never changes. so to make it easier to read, i would like to merge these cells (which are the same) together?


would become.... (with all the other data the same)




I dont want to lose any of the rows, as the data in column C is always different. I just want to merge the similar ones, so its easier to read.

Its a bit like this, but i cant even come close to getting this to work:

I am trying to find duplicate values in one column and combine the values of another column and separate them with a delimiter e.g. ";". I may have more than 3 columns.



I appreciate your help



Is this possible, in a column, identify and merge duplicate values using macro. I found a post here about Identifying Duplicate Rows but having difficulty modifying the code. (Newbie)


Hi, I'm trying to do a mail merge from excel to a word doc. The excel sheet has some duplicate records, which I need to print. When I merge it, and look at the data one record at a time, the duplicates are there. However, when I loop them onto a page, it extracts the duplicate. Is there any way to keep the duplicate???

Thank you


I have a workbook where I need to combine/merge data from one sheet into the other. However, one of the sheets has multiple records for the same lookup criteria (PERNR: Personnel Number, BEGDA: Start Date) but not the other. Hence I need to duplicate rows in the sheet with single records (IT8) so that the sheet with multiple records (IT0) can be assimilated.

In the attached example, I want to map each individual record in IT0 to one in IT8 by concatenating and vlooking up both PERNR and BEGDA. The check column indicates that there are multiple IT0 records for the same PERNR on the same BEGDA. I intend to pivottable the data later as well to display the number of affected IT8 and IT0 records separately.

Currently, a vlookup done in IT8 will only provide details of the first IT0 record for the corresponding PERNR and BEGDA (as in sheet "Current"). Is there a macro to:

1) Add new rows to the multiple records respectively? (i.e. 2 rows for IT0 records with same PERNR/BEGDA, 3 rows for 3, 4 rows for 4...) - Sheet Step 1

2) Copy the existing IT8 records into the blank rows? (i.e. Duplicating the IT8 records of the same PERNR/BEGDA) - Sheet Step 2

[1+2 = Duplicate IT8 records to so that each IT0 record can be mapped to each IT8]

3) Filling in the multiple IT0 records which were skipped by vlookup? (i.e. Mapping each individual IT0 to an IT8) - Result

Or is there any other non-manual way (formula, etc.) to merge the sheets as there are thousands of records?



I am trying to create a spreedsheet that analyzes the price changes between months. I have been given two workbooks that contains data for the year 2010 and 2011 YTD. I do know how to locate duplicate data in the same column betwen I don't know how to combine the corresponding row values. What I want to do is merge the values and delete the duplicate row. In the attachments provided I have somewhat minimized the data by only including the batch month that I want to be included.

The duplicate values that I would what to be meged will be in column B (Shipment_ID), the corresponding values that I what to total will be in column S (GL_Allocated_Amount).

2010 and 2011.xls

Any help will be appreciate.


I would like combine (overlay) a bubble chart with a connected point scatter chart.

I understand that, without VBA, this is not possible. However, I understand that, by using VBA, the markers of a scatter chart can be configured as circles with their size proportional to values in a specified column.

This pseudo-bubble chart can then easily be combined with a connected point scatter chart.

Unfortunately, I am a VBA newbie, and so I cannot yet write my own code. However, I can usually adapt other people's code to my specific environment without a problem.

My question is: does anyone have any VBA code to share that shows how to configure a scatter chart as the type of pseudo-bubble chart described above.



Just wanting to know if it was possible to make gridlines in a chart overlay.

I have a column chart and would like the gridlines to overlay the columns.



Hello, everyone!

I'm working on a massive file that I need to consolidate.

Is there a formula or a code that will help me merge duplicate entries? I've tried codes and formulas that leave blank cells after the first value but this still means I have to manually merge the topmost value with the remaining blank/duplicate cells.

Excel problem.jpg

Thank you!


I'm trying to merge all of the same orders items into one row so when I import it to my shipping software it recognizes one line with all the items rather then 1+.

See attached.

Column 'I' displays the order ID I Excel to recognize duplicate order ID's in row I say order ID 9970822 for example there's another line for it. Print message = Item. So I'd want it to merge both printed messages for the duplicate ID so It'd printed message will be: AP1CT=3 /2085 1 AP2CT=3 /2086 1


Willing to donate to one who finds a key to this solution of time-saving. Big help, thanks!
Skype: dr_jcohen

Basically, we have duplicates in our master call list and would like to erase the duplicates while salvaging the information that is within the duplicate. The problem is, when there is a duplicate, we have two entries; each entry having information different from the other. I would like to find out how to merge the entire row of the duplicate in that where information is missing in the original, it can be attained from the duplicate.

The end product would have no duplicates and any row that had a duplicate, would have the duplicates info in their row.

Ive attached a sample of the sheet with about 30 rows. It has over 11000 rows, so doing this manually is out of the question.

Any help would be greatly appreciated!!

it would also be great if any responses could be emailed to and


I have thousand rows wihich contains duplicate rows with some unique data. I want merge duplicate rows so last column (location) all values remain. It is important the solution is simple and quick beacuse this kind of table is needed to do monthly.

More precisely what I need.xlsx

Please help!

Hey Guys,

So I am trying to combine the duplicate name and combine the numbers into one sum for each person. Can someone please help?


Hi , many thanks for looking, I have attached a workbook which shows my desired output to make it easier to explain.

However, here is a brief explanation

Col A show pairs of duplicate values.

There are two rows per duplicate value with data belonging to each record in range B:BD

I need to merge the data from range B:BD into one row per duplicate record

If as in Cell B2 and B3 if a 1 appears in both the merged row should only contain one 1.

I have tried and failed to adapt this code taken from the internet!!

Please Login or Register  to view this content.

Many thanks for looking

Hi again
I have been working with 2 sheets of data that I wanted to combine into one sheet. I wanted to keep all the data in both sheets but bring it together. I used the merge sheets and am now unsure exactly what this has done? Have the feeling that some data may have overwritten..
Can someone explain what merge sheets does, and if it can be used to combine 2 sets of data?


I have two columns of text that I want to combine (but not concatentate) e.g.

The first column has no nulls but I want to replace wqith a value from column two.
Column two has nulls but I dont want to overwrite column 1 with these nulls i.e. I want to keep column 1 text.

Please see attached example.

I hvae minimal experience with this kind of excel problem.



hi all, have to merge two columns of names into one. in Column A, I have our business contacts, and in Column B, their partners/wives names. I need to create one list in the same order as Column A. I thought that by inserting a new blank row between each existing row in Col A would be the start. But then how do i overlay the Col B names into the new blank spaces??

any suggestions?


Can I please get some help in coming up with a macro.

We get these three reports from our different routes, attached is a sample workbook with worksheets (Projects, Tasks and Details), the data in them varies by location and month but the format remains the same. Currently I manually consolidate and merge these sheets to combine the data together.

The ID is the unique identifier among all the three sheets.

1. First I combine the data from Projects and Tasks into Results, if the ID is common and duplicate, then the data is copied and pasted into the result.
2. Then I look up the duplicates between the Details and the Result, and paste the duplicate records under the ID's, to come up with the RESULT sheet as it is displayed in the workbook.

I have color coded them in the Results worksheet to better help in understanding the data.

What I want to be able to do is:
1. Have a Macro that looks up the duplicates between Projects and Tasks and Details.
2. Merge and consolidate the results in the Result sheet.
3. If there are any missing records (eg id 1005 is missing in Tasks) then either note it as missing or if possible throw it out as an exception in maybe another sheet.

Can someone please help me with this? I will really appreciate it.
If you need any more clarification please let me know.

Regards and thanks in advance.

I have two separate worksheets and each worksheet has a pivot table. Is there a way to combine the two pivot tables. Basically the area that counts the data need to be combined.

I can do the obvious which is of course copy each for values only and merge them that way but thought there was a way to merge two pivot tables.

My supervisor wants me to figure out how to merge two files (we know how to
do this) but then set it up so that if there are any duplicate cells/cell
rows in the two files, they will automatically delete. Anyone know if this is
even a possible function?

I have a very large database of records, I need to merge the duplicate rows, leaving the most recent activity modified time.

I have attached a sample sheet.

Can anyone help me with a formula to do this?

Im new around here, so I dont know if this has been discussed previously or not. My apoligies if it has been, but I could still use some help...

I am trying to create a normal distribution based on a specific mean and standard deviation (that I will be able to change), so that I can overlay this distribution overtop of another graph. I would ideally like to create the graph of the normal distribution based simply on the parameters, that is, withOUT having to create data to do it. Is this possible?

Additionally, I have tried a couple of things, and I can get the normal distribution to graph by itself (but the method is somewhat cumbersome). When I try to do two series on the same graph, the mean of the normal distribution shifts for some reason away from the value that I manually specified.

If anyone has any suggestions, I would greatly appreciate them. Thank you in advance!!