Mapping a Cell then adding 12 cells down

[Tripp K]

I need some help. I have a two column table that the information was entered
in going North/South rather then East/West. So I am trying to correct this
by mapping a cell =Sheet1!B1 which has a value of company name, and then
going to the next row and putting in =Sheet1!B7 because there are 6 rows in
between each new entry. Is there a way to automate this process so that I
don't have to manually put in all of these mappings. So I basically just
want something like on Sheet 2 the 2nd Row cell would be something like
=Sheet2!B1+6, where Sheet2!B1 is equal to Sheet1!B1.

Hope that makes some sense. Thanks in advance

 

[Bob Phillips]

=INDIRECT("Sheet1!B"&(ROW()-1)*6+1)

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)