View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
DLN DLN is offline
external usenet poster
 
Posts: 1
Default 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.