Is there a way to........

Giganews Newsgroups
Subject: Is there a way to........
Posted by:  ktfrubel
Date: Fri, 24 Aug 2007

covert an entire spreadsheet from a column format to a row format?

I have a spreadsheet that was given to me that has about 1150 entries. The
format that the came to was:

City State

The format I need to get is

Name              Address                  CityState                Zip

Is there a way to change this in one fast way instead of having to copy
paste special each one?