Hi -

I have a file of data that I need to flip rows and columns, however, there
are multiple sets of data so the "paste specialtranspose" doesn't meet my
need. So, for example, my current data file looks something like this:

A B
City Ozark
State MO
ZIP 65721
City Kansas City
State MO
ZIP 64118
City Suffolk
State VA
ZIP 23434


And I need to transform it into something like this:

City State ZIP
Ozark MO 65721
Kansas City MO 64118
Suffolk VA 23434

Is there a systematic way to accomplish this in Excel???