Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Rows to Columns
Hi,
I get info coming in that is formatted :- 08-Aug 02:42 08-Aug 07:29 08:10 09:58 10:45 11:58 13:33 09-Aug 04:57 09-Aug 06:28 09:46 10:32 11:28 12:44 13:44 This goes on for the entire month. I need it formatted as:- 08-Aug 02:42 08-Aug 07:29 08-Aug 08:10 08-Aug 09:58 08-Aug 10:45 08-Aug 11:58 Etc. Anyone got any ideas of a quick way of doing this? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
Combine multiple columns into two long columns, Repeating rows in first column | Excel Discussion (Misc queries) | |||
how to interchange rows to columns & columns to rows in a table | Excel Discussion (Misc queries) |