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!