LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Line Up Two Columns In Excel

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 03' columns don't line up after pg 10 when printing/previewi gep6 Excel Discussion (Misc queries) 0 December 8th 08 04:41 PM
what are the columns (1 2 3) which appear right of line # column deadwood Excel Worksheet Functions 1 October 26th 06 03:58 AM
How do you select line or columns in "Line-Column on 2 axes" graphs? mizterbusy Excel Discussion (Misc queries) 0 September 19th 06 06:48 AM
how to line up different columns of data np Excel Discussion (Misc queries) 0 August 21st 06 08:38 PM
counting line by line matches of 2 columns possible in excel ? Medikto D Excel Discussion (Misc queries) 3 June 1st 06 05:46 PM


All times are GMT +1. The time now is 07:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"