Transpose a repeating grouping of rows to colums

[KCraig]

Hi all :

I dug through several of the questions archived here, but couldn't find this situation.

Hope this is an easy one.

I've got a series of rows, which all have the same number of entries.

For example,

Name: Data Name
Rank: Data Rank
Serial Num: Data Serial


Each grouping has an empty row between them.

Is there a way to transpose this table so it's oriented in columns?

For example:

Name ; Rank ; Serial Num
Data Name ; Data Rank ; Data Serial



Thanks all.

Kcraig

[coray80]

Code: Select all

=INDEX($A$1:$A$16;((ROW(A1)-1)*4)+COLUMN(A1);0)

dragged across 4 columns and down as far as neccessary