Count one cell and then count 52 cells later...

Folks,

I'm a newbie to these forums, but I had a question that I couldn't find an answer to in the search feature. So, I joined and here I go....

I have a whole lotta data (nearly 600 "pages" of data) that I pasted into Excel. Unfortunately, it's formatted poorly and I'd like to make it nice and purty.

What I started to do was to create a 2nd sheet and then do an "=" and then click the spot with the 'group name' and then another "=" underneath it and then clicked the spot with the 'premium' info, etc.

After a couple of these, I figured that I could simply make a formula to help me out with it. Please see the attached screen captures for some detail on my issue.

Can someone help me create a formula or a way to count a certain cell and then 52 cells underneath it and display it?

=a1+a53 ??

Sorry, I must've not explained it correctly. It's late in the day for me

I actually want the data from the first screen print (there are like 600 fields like that down and separated by 52 cells) to be "moved" to another area where I can list the 'group name' and 'premium', 'claims' and 'percent' on one row.

So, rather than deleting a ton of rows and trying to line things up, I wanted to do something easier.

its easier to see from a workbook with some fake data than from images!

I agree with Martin... a sample would be helpful, the screenshots aren't a great deal of help in truth.

You can as a pointer use INDEX to retrieve data from stepped ranges...

A1 on Sheet2 = A1 from Sheet1
A2 on Sheet2 = A53 from Sheet1
A3 on Sheet2 = A105 from Sheet1
etc...

Sheet2!A1: =INDEX(Sheet1!A:A,1+(52*(ROWS(A$1:A1)-1)))

That give you an idea ?

(INDEX is preferable to OFFSET given OFFSET is Volatile)

Thank you DonkeyOte! :D

That, in theory, is what I'm looking to do

I'm going to play with that and see if it works for me....then, I'll post back.

Sheesh, I came back today for another Excel question and just realized that I never went back to place this one on "SOLVED" status

Thanks Donkey!