| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need to seperate every 6th row out of a column?
I'm look at hourly weather data for the last 6 months. I need to find a way
to take only one piece of data from one column but every 6th hour and put in a seperate column for further anaylis. Say the data I need to look at f6, f12, f18, etc through fwhatever. Is there a 'formula' and/or way to have Excel cut these cells, then paste them into consecutive rows such as M1, M2, M3 etc through Mwhatever? So far I've got about 4500 lines to go through for 25 different sites. HELP. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| need surnames in a column in excel seperate from the first names | New Users to Excel | |||
| seperate first 2 lines of column in seperate columns in same row | Excel Discussion (Misc queries) | |||
| Seperate Data in one column into two columns? | Excel Worksheet Functions | |||
| Excel - returning column headers in a seperate column | Excel Discussion (Misc queries) | |||
| how do i seperate data from one column into two seperate ones in . | Excel Discussion (Misc queries) | |||
Threaded Mode
