Hi,

I have contact information, name, address etc all in column A. Each group
is separated by a row with a 0 in it. I need to transpose it to columns.
Thanks to Biff's help in a previous post, I have this formula to do this:

=INDEX(Sheet1!$B:$B,(ROWS($1:1)-1)*7+COLUMNS($A:A))

The problem is that some of the groups have 4 rows of data, some have 8 and
others somewhere in between. Plus the row with the 0 between each group
throws stuff off too.

So what can be added to this formula to accomplish this.

Thanks!!