I have a file with one column as follows:

Name
Address
Address2
City, State, Zip

Name
Address
Address2
City, State, Zip

etc.

I need to transpose into columns for mail merge - so transpose the 4 rows
into columns, then go down a line, transpose into columns, etc. so each
address is on a new line. I tried using the TRANSPOSE function, but I can't
get it. Any thought? Thanks!