Merging Columns of Data

HELP!

I have seen the concatenate function, but not sure if it would apply here...

I have a list of accounts and serial numbers and two date columns that I would like to combine and sort.

Column G = Warranty End Date
Column H = Support End Date

I would like both of these columns combined for one master list of dates available to sort in ascending order with corresponding account and serial number data. HOWEVER, some accounts have dates listed in BOTH of the columns - in which case I'd like column H to take precedence.

Any help would be greatly appreciated! I'm STUCK!
Ruby

If you want to sort bt the date in H unless J has a date and you want to sort by that instead maybe you could insert a new column after these two (Col K) and in K1 type:

=IF(J1="",H1,J1)

Then you can use this column to sort with.
Is that what you're after?

No prob, sometimes it's good to take a step back and see it from a different point of view.

If you are satisfied that this answers your query can you please take the time to mark the thread as 'Solved' by clicking on thread tools near the top of this page and marking solved.