How can i stagger the contents of the following row using a formula? I want to stagger by different numbers of columns so row 2 might be identical data to row 1 but shifted right by a number of columns.
so for instance, if i stagger by 1 (always to the right) the first row will have 0 1 2 3 4 5 6 7 8 9, the next row will have 1 2 3 4 5 6 7 8 9 0, the third row will be 2 3 4 5 6 7 8 9 0 1 and so on
If I stagger by 2 it'll be 0123456789, 2345678901, 4567890123 and so on.
On a small scale I can do it by hand but this will be 365 columns and 10 rows and i want to try staggering by 0 to a max of 67 columns so id like a formula i can drag and fill!
Row 1 will always have the original data set.
I know there are functions which work with cell reference but i cant remember what they are called so its tricky to google them.
Thanks in advance!
so for instance, if i stagger by 1 (always to the right) the first row will have 0 1 2 3 4 5 6 7 8 9, the next row will have 1 2 3 4 5 6 7 8 9 0, the third row will be 2 3 4 5 6 7 8 9 0 1 and so on
If I stagger by 2 it'll be 0123456789, 2345678901, 4567890123 and so on.
On a small scale I can do it by hand but this will be 365 columns and 10 rows and i want to try staggering by 0 to a max of 67 columns so id like a formula i can drag and fill!
Row 1 will always have the original data set.
I know there are functions which work with cell reference but i cant remember what they are called so its tricky to google them.
Thanks in advance!