Hi,

I have a HUGE column of heart rate data, every 2 secs the heart rate for about an hour. I have tanken an average for every ten seconds in a separate column. But I need to put all this into one uninterrupted column so I can put it next to other data that I have.

At first I tried typing in a new column, for example, =J20 then =J25, then =J30 etc and dragging this formula down in the hope it would continue the pattern adding five each time. It didn't

Then I thought, oh i'll try making a macro. So I made a column with basically the five times table running down, and recorded adding =J to the beginning of the first. I tried running this on the next, but it changed the number next to it too.

I have never used macros, and I have so much data here, and hours and hours more of this heart rate data to process in this way - I desperately need to find a way to not have to do it all manually...

I hope I have explained the situation clearly... any help is very very greatly appreciated!

Thank you in advance