If cells in column match, merge other cells together

[cp49321]

Hello,
I am trying to match 2 databases to make one usable sheet. I have them merged based on the original database, I would like
to have if:A2=A3, I would like to have G2:H2 move to G3:H3, and delete row 2.
I hope this is clear, I am not able to make this work
Thanks in advance
Danny

[JBeaucaire]

To make it 100% clear, add a second sheet to your sample workbook that shows the AFTER results exactly as you would from the sample data. Add more data if you cannot properly represent all the scenarios that have to be "resolved" as data is copied and rows are deleted.

[Mallycat]

Hello,
I am trying to match 2 databases to make one usable sheet. I have them merged based on the original database,

It would be helpful if you were clearer about what you want. What does "match 2 databases" even mean? Are you saying you are trying to join the data from 2 separate databases based on a common key? What does "merged" mean?

[icestationzbra]

if i understand correctly what you are looking for, it might be best done using VBA.

however, i have attempted a roundabout way of getting close to your stated intentions using some formulae. is this what you are looking for? if it is, then building up on it might not be too difficult (i mean the columns that i have left blank on the second tab).

cp49321_tool-search_07apr12_01.xlsx

[cp49321]

Thank you,
Icestationzbra, that is what I am looking for, item QE-001368 I need to find a cert. date for since it is not in both.
I am using Gagetrak(for all calibration data) and also Syteline(for location only).
I have one database I track tool locations in, and another that I track certification and due dates in.
Making the best of it, I am looking to create a list of items due for calibration, and the location, based on
my databases. It would be much easier if they lived in the same database, but sadly they do not.
Any unique items I need to get logged into the correct location.
Thanks for the help,
Danny

[icestationzbra]

how did you arrive at "ERP" in the last column? is it just a default for every row? or does one row preponderate over the other?

you did not fill out Gage/SN, Type and Note columns in the spreadsheet you uploaded in your latest update, hence i left them blank in mine. if you needed them filled out the logic would be akin to adjacent columns'. if you are feeling up for it, you might want to give it a try.

take a look at the formulae for each column to understand how they are bringing back values in order to determine if the logic is fallacious. if so, explain how else might the values be brought in.

[cp49321]

Good morning,
The "ERP" only shows the database(Syteline) that is master for item location-I put that in to help sort for matches and show where data came from.
The Gagetrak no longer has the location kept active, only calibration data. The items that do not match either column A I need to find an enter a location.
I am trying to establish location, and what items are not matching either list, in order to create calibration due listings.
This is not the best system, but since the databases are not linked I am trying to simplify things!
Thanks for all of your help!
DH

[icestationzbra]

i am unable to comprehend much of what you have said above, since i am clueless about your business.

let's work with specifics.

would you like Gage/SN, Type and Note columns filled out similarly to the others?

is ERP the right value to appear in the aggregated Database column?

[cp49321]

Hello and thanks again.
I am in charge of gage calibration in a mfg. company. I use Gagetrak(gager) software to track all gage information, but all company wide movements of gages are done by using
Syteline(ERP). Since the 2 databases do not read each other(long story) I have convinced management to allow me to make the process use Gagetrak for everything except current location,
and Syteline as the master of current location, so I am forced to take an .xls dump of Gagetrak, an .xls dump of Syteline, and match the rows by QE- number, also showing all that show up
not on each list on page 1(I just paste and sort by column A). Page 2 has exactly what I need, it shows the matches with the last cal. and next cal due date, it shows QE-001368 with no cal.
date(so I need to verify the date on gager)date, and QE-Eric cartman as not on the ERP list but in gager(as planned). I like the ERP in the last column.
I will pass this list to each location to show gages due.
If I have several thousand entries,can I paste or insert them on page 1, do I just copy the formula down that is on page 2?
I appreciate your help!
Thanks,
Danny

[icestationzbra]

you can start by doing exactly what you are doing right now - data dump from Gager pasted on Sheet1, and then from ERP pasted below that on Sheet1, followed by sort-by-name on Column A. with that, let us say you have about 100 rows of records.

on Sheet2, "highlight" (not drag) the entire Row2 from Column A to Column I. then use the fill-handle to drag the highlighted portion down approximately 100 rows and then let go of the fill-handle. then you will see that the data probably stopped appearing much before the 100th row (because the duplicates were weeded out).

give it a try and revert here in case of issues.

as always with any software-based tool, there is no substitute to 'real-life' data and thorough testing.