Thread: Sort two different groups of data

I have two different databases that could have new numbers in each database. I need them to align up together while inserting blank cells where they don't align up. I've looked and can't find anything. Here's an example. Thanks for any help.
----------------------------
ca01 $1.00 ca01 $1.00
ca02 $1.00 ca02 $1.00
ca03 $1.00 ca04 $1.00
ca04 $1.00 ca05 $1.00
ca05 $1.00 ca06 $1.00
ca07 $1.00 ca07 $1.00
ca08 $1.00 ca08 $1.00
----------------------------
Needs to be
ca01 $1.00 ca01 $1.00
ca02 $1.00 ca02 $1.00
ca03 $1.00
ca04 $1.00 ca04 $1.00
ca05 $1.00 ca05 $1.00
ca06 $1.00
ca07 $1.00 ca07 $1.00
ca08 $1.00 ca08 $1.00

When I posted the text shifted. The ca06 $1.00 needs to be in the second column.

I'm going to have over 20,000 records to check the prices with two different groups (pricelists) of data, so any help would be appreciated.