wilsonds wrote...
....
An example of what I'm looking to do is below

ORIGINAL
ID FIRST LAST ZIP
1 Bob Smith 63101
2 Jane Doe 63105

NEW TRANSFORMED DATA

ID 1
FIRST Bob
LAST Smith
ZIP 63101
ID 2
FIRST Jane
LAST Doe
ZIP 63105

Uncrosstabbing. The general approach uses INDEX, INT, MOD, COLUMNS and
ROWS functions. For my conventience, I'll assume your original data
range is named D and the top-left cell of the result range is G1.

G1:
=INDEX(D,1,1+MOD(ROWS(G$1:G1)-1,COLUMNS(D)))

H1:
=INDEX(D,2+INT((ROWS(H$1:H1)-1)/COLUMNS(D)),
1+MOD(ROWS(H$1:H1)-1,COLUMNS(D)))

Select G1:H1 and fill down as far as needed.