Biff,

Thank you too. My problem has been solved.

Regards,

Stan

"Biff" wrote:

Hi!

Try this:

=INDEX($A:$A,(ROWS($1:1)-1)*13+COLUMNS($A:B)-1)

Copy across to 13 cells then down as needed.

Biff

"stansdl" wrote in message
...
I would like to take the first 13 cells in the column and display in one
row
and then the next 13 cells in the next row and so on...I have seen many
posts
that come close but I was not able to get them to suit my needs. Thanks
in
advance for your help.