| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to re-layout data
hi guys, here i got a question as below. can anybody kindly help on this? thanks in adv. Original layout: ColumnA ColumnB ColumnC 2006-6-28 9:00 24465 2006-6-28 12:00 25609 2006-6-28 15:00 27295 2006-6-29 9:00 27309 2006-6-29 12:00 27312 2006-6-29 15:00 24465 2006-6-30 9:00 27295 2006-6-30 12:00 27302 2006-6-30 15:00 27309 ...... I wanna re-layout it listed in this format: NewColumnA NewColumnB(9:00) NewColumnC(12:00) NewColumnD(15:00) 2006-6-28 24465(ColumnC1) 25609(ColumnC2) 27295(ColumnC3) 2006-6-29 27309(ColumnC4) 27312(ColumnC5) 24465(ColumnC6) 2006-6-30 27295(ColumnC7) 27302(ColumnC8) 27309(ColumnC9) ...... if there is any method or function to do this automatically? -- netfan ------------------------------------------------------------------------ netfan's Profile: http://www.excelforum.com/member.php...o&userid=31349 View this thread: http://www.excelforum.com/showthread...hreadid=556167 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pull data from another sheet based on certain criteria | Excel Discussion (Misc queries) | |||
| Inserting a new line in spreadsheet | Excel Discussion (Misc queries) | |||
| Importing Data | Excel Worksheet Functions | |||
| Saving data in a worksheet within a workbook | Excel Discussion (Misc queries) | |||
| Line Graph Data Recognition | Charts and Charting in Excel | |||
Threaded Mode
