I am trying to get a series of data points into one column, but each point that i want next to each other is 10 cells away from the previous. These ten cells are also full of data, thath i want to keep and arrange in a similar way. The crux of the problem seems to be that i can't change the increment for relative addresses from 1 to 10 i've tried formulae like A(1+10)but its not working.
ta
ben
ta
ben