Transpose certain rows to columns

[metal90]

Hi guys,

I have a doubt about transposing rows to columns. When i searched the internet i could find solutions for transposing the entire row to column. But i need to transpose a set of 8 rows at a time (which represents a single person's information) to columns (Please see my attached excel sheet sample). Is there an excel formula to do this?
Thanks in advance

[Pete_UK]

Put this formula in C1:

=INDEX($A:$A,MOD(ROWS($1:1)-1,8)*8+COLUMNS($C:C))&""

then copy across to J1. Then copy the formulae in C1:J1 down as far as you need to (i.e. until you get blanks).

Hope this helps.

Pete

[metal90]

Thanks Pete_UK. That worked perfectly !! Cheers.