Get Data in column A to populate into multiple columns

[dawsonsoo]

Hi,
I have single values in each cell in column A. I have 100 rows.

I want to take six rows at a time and get them to populate columns B, C, D, E, F, G.

Is there a simple formula for this? Please advise, thank you!

~S

[Ace_XL]

With your data starting in Cell A1 use

In B1
=INDEX($A:$A,COLUMN(A1)+(ROW(A1)-1)*6)

Copy down and across as far as you need

[dawsonsoo]

Wow, that worked wonderfully! Thank you so much.