Quick way would be to Select the column starting with the first time,
and copy and then paste in the second column next to the first date.
Then select both columns, Data Sort, and then delete the rows that start
with "time".

Constance wrote:
I have some dates and times in one column that I would like to line up the
dates with the times in the adjacent column. Please see example below:

Present display Would like displayed as this
5/31/07 5/31/07 11:30
11:30 5/31/07 13:20
5/31/07 6/1/07 10:30
13:20 6/1/07 15:30
6/1/07
10:30
6/1/07
15:30

I apreciate the assistance.