I'm looking for help with a cell reference formula in excel. These are the facts:

Cells A1:A5 contains the following numbers, starting at A1 and moving downwards; 1, 2, 3, 4, 5

I want to copy these cells to B1:B5.

This is where it gets tricky..

I then want to fill cells C2:C6 with the same numbers (1 through 5) for n number of columns such that each time I fill to the next column on the right, the first number "1" starts 1 row down.

I'm looking for a formula that would do this in Excel, not VBA code.

Thanks very much!