Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have two databases that I am trying to merge into a single excel worksheet.
The first column in each database is a unique ID number associated with the data in a single row. I need to line up the unique ID columns (one from each database) in order to merge the data. The problem is that the two databases do not have the same number of entries. For example, UniqueID1 UniqueID2 1 1 2 3 3 4 4 5 and I would like to sort or line up the columns so that it looks like this UniqueID1 UniqueID2 1 1 2 3 3 4 4 5 and leave blanks where they do not match up. Is this possible to do easily in Excel? Thanks! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 03' columns don't line up after pg 10 when printing/previewi | Excel Discussion (Misc queries) | |||
what are the columns (1 2 3) which appear right of line # column | Excel Worksheet Functions | |||
How do you select line or columns in "Line-Column on 2 axes" graphs? | Excel Discussion (Misc queries) | |||
how to line up different columns of data | Excel Discussion (Misc queries) | |||
counting line by line matches of 2 columns possible in excel ? | Excel Discussion (Misc queries) |