More than a simple column to row transformation

[testingforms]

Hi, all,

I have one column of data with four distinct variables that I would like to transpose into rows. The data look like this:

COLUMN A
Name1
Age1
Gender1
Birthday1
Name2
Age2
Gender2
Birthday2
Name3
Age3
Gender3
Birthday3

I would like to make them look like this:

COL A | COL B | COL C | COL D

ROW1 Name1 | Age1 | Gender1 | Birthday1
ROW2 Name2 | Age2 | Gender2 | Birthday2
ROW3 Name3 | Age3 | Gender3 | Birthday3

Does anyone have any suggestions?

Thank you so much!

[zbor]

Here, try this:

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

and pull 4 places right and down as it takes.

(replace ; with , if needed)

Edit: OK, better would be: =INDEX($A:$A;4*(ROWS($A$1:$A1)-1)+COLUMNS($A$1:A$1))

[testingforms]

Thank you! I was able to use an augmented version of the formula for just what I needed.