Close Window   
Free Ebook
Get Your Free Excel
Our Top 15 Excel Tutorials
Instant Access!
Subscribe for Free Excel tips & more!

Merge/combine/overlay But Dont Duplicate???

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

View Answers     

Similar Excel Tutorials

Easily Compare Duplicate Values in Excel
Here, I'll show you a simple technique to quickly and easily compare large lists of duplicate values.  This allows ...
Highlight Duplicate Values in Excel
How to highlight duplicate values in a list. Also, how to arrange those values next to each other so they are easy ...
Combine Values from Multiple Cells into One Cell in Excel
There are two easy ways to combine values from multiple cells in Excel. In order to do this, we need to do what is ...
Center Titles Across Multiple Cells in Excel
How to center a title across multiple cells in Excel in order to make good looking titles for your spreadsheets. S ...

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

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,

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!

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!

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.

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!!

Is it possible to combine to spreadsheets and then delete the duplicate records?

Hi, I have two sets of age profile data, one for a small area and would like to overlay the chart over a state profile to demonstarte the difference. Does anyone know if this possible? Giles

I wish to import a csv file into an existing spreadsheet so that the non-blank fields in the csv file fill in the correspnding cell in the spreadsheet and leave the others alone.
But when I use Import (or even copy and paste), the blank (ie null) fields in the csv file overlay all the fixed cells basically wiping out many existing spreadsheet fields.
Is there maybe a value that can be put in csv field to say "dont overlay the cell this would normally go in"?

I have a bar graph showing electricity consumption in a hotel over the last 3 years to view if energy saving initatives are working. What I need to do is to overlay an occupancy graph over this so I can see occ vs. Electric bill. Is this possible?

Hi i need to combine and merge difefrent data into groupings. EXAMPLE

1 a x
1 b x
1 c x
2 a x
2 b x
2 c x

It needs to end up as
1 a x
2 b
With a 2 or 3 empty lines until the next set of data
But if for example i have this:

1 a x
1 b x
1 c x
2 a x
2 b x
2 c z
3 c z

I need it to combine like
1 a x
2 b

1 c x

2 c z

I hope you get what i mean. Hopefully you have an idea on how to solve this.. The data is always just 3 colums wide. As i have some things that i need to combine that are 4000 line or more it takes a whie to sort it manually.
If you have a formula or macro that i can make to speed it up i would appreciate it.


Require some code to combine columns and remove duplicate content, e.g.

Combine A and B and remove duplicate content (from B) and output into C.




Please note how "money" in column A does not end up in column C

Thank you.

Using Office 2003, have a SS with addresses, have merged into word to create
mailing labels works fine....I need to create membership labels....2 of the
same address to a there a way to merge the SS into word without
creating duplicate rows in the SS...This is a huge membership list.