Rearranging data in one column into two columns
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.
--
Constance
|