I have a large file of 1.1 million rows.

Each row contains information for a single user in 4 columns. The columns are:

First | Last | Zip | State |


My problem is that I need to format the information so that each row (or user information) becomes 2 rows and 2 columns. For example. The layout above would become:

First | Last
Zip | State

I need to do this for 1.1 million rows of user information.

Is this possible in excel and if so, how would I go about doing it?