Copy cells in a specific pattern
 

Hi, I have a spreadsheet with daily data (mon-fri). I would like to transform
this into weekly data (starting on mon). My solution for this was to create a
column with the following pattern:
A1
A6
A11
And use the fill pattern to complete all 1000 observations. My problem is
that Ecxel is not continuing my pattern, but starts over after 3 observations:
A2
A7
A12

A3
A8
A13
and so on...
I don't want it to follow this pattern, but just continue...
Can anyone help me with this problem?

- Cornelius

Copy cells in a specific pattern
 

Assuming your original data is on 'Sheet1', and begins at row 1 as per your
example, then on the other sheet, enter this formula in a cell on row 1:

=OFFSET(Sheet1!A$1,(ROW()-1)*5,0)
and fill it down the sheet. It will pick up A1, A6, A11, A16, A21, etc.
from Sheet1


"Cornelius" wrote:

Hi, I have a spreadsheet with daily data (mon-fri). I would like to transform
this into weekly data (starting on mon). My solution for this was to create a
column with the following pattern:
A1
A6
A11
And use the fill pattern to complete all 1000 observations. My problem is
that Ecxel is not continuing my pattern, but starts over after 3 observations:
A2
A7
A12

A3
A8
A13
and so on...
I don't want it to follow this pattern, but just continue...
Can anyone help me with this problem?

- Cornelius

Copy cells in a specific pattern
 

Another option
Place in any starting cell, eg in C2: =INDEX(A:A,ROWS($1:1)*5-4)
Copy C2 down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Cornelius" wrote:
Hi, I have a spreadsheet with daily data (mon-fri). I would like to transform
this into weekly data (starting on mon). My solution for this was to create a
column with the following pattern:
A1
A6
A11
And use the fill pattern to complete all 1000 observations. My problem is
that Ecxel is not continuing my pattern, but starts over after 3 observations:
A2
A7
A12

A3
A8
A13
and so on...
I don't want it to follow this pattern, but just continue...
Can anyone help me with this problem?

- Cornelius

Copy cells in a specific pattern
 

Thank you so much!! I just saved a lot of work:)

- Cornelius

"JLatham" wrote:

Assuming your original data is on 'Sheet1', and begins at row 1 as per your
example, then on the other sheet, enter this formula in a cell on row 1:

=OFFSET(Sheet1!A$1,(ROW()-1)*5,0)
and fill it down the sheet. It will pick up A1, A6, A11, A16, A21, etc.
from Sheet1


"Cornelius" wrote:

Hi, I have a spreadsheet with daily data (mon-fri). I would like to transform
this into weekly data (starting on mon). My solution for this was to create a
column with the following pattern:
A1
A6
A11
And use the fill pattern to complete all 1000 observations. My problem is
that Ecxel is not continuing my pattern, but starts over after 3 observations:
A2
A7
A12

A3
A8
A13
and so on...
I don't want it to follow this pattern, but just continue...
Can anyone help me with this problem?

- Cornelius