Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Rearranging and Indexing a column array | Excel Discussion (Misc queries) | |||
rearranging data | Excel Worksheet Functions | |||
Rearranging cells into certain columns | Excel Worksheet Functions | |||
Rearranging columns/rows | Excel Discussion (Misc queries) | |||
Rearranging Data Help... | Excel Discussion (Misc queries) |