Rows to columns with a twist

[bcone]

I have a workbook with repeating data in one column and unique data in sets
of 5 rows in the next column:
A 1
B 2
C 3
D 4
E 5
A 6
B 7
C 8... etc

I would like to transpose to:
A B C D E
1 2 3 4 5
6 7 8... etc

 

[bcone]

I don't recall who's responsible for this equation but it worked along with
some manual manipulation: =INDEX($A:$A,COLUMNS($A:E)+6*ROWS($1:1)-6)

Pulling the function along the row transposed the rows in column A to column
headers. Pulling the function down one row then to the right one column and
then down till the data in the column was all similar data... and repeating
until each column was filled with the desired data... worked great. Then I
simply copied and "paste special - values' into a new worksheet.

Thanks!