line up columns in Excel

[jvdub22]

Im writing a program that takes 2 or more recordsets and dumps them into columns in Excel. Im dumping the recordsets one at a time. Once in Excel I need to line up the matching cells and shift non matching cells into a new row. What I need help with is the matching and shifting of the cells. For example if my spreadsheet has 4 columns that looks like this:

Recordset1     Recordset 2     Recordset3     Recordset4
 
   b              a              b               a
 
   c               b              c               d
 
   d               d              d               f
 
   e               e              f               g
 
    f
 
My program needs to sort the columns so that my spreadsheet looks like this:
 
                   a                               a
 
   b               b               b                      
 
   c                               c               
 
   d               d               d               d
 
   e               e                                             
 
   f                               f               f
 
                                                   g

Im having trouble writing an excel macro to compare the columns to see if they should line up and how to do the shifting of the cells if they dont match. Any help would be appreciated.