Moving data: vertical to horizontally laid cells

[Edward Chambers]

Does anyone know an automated way to get data that is listed in cells going
down the page (vertically) into cells that go across the page (horizontally)?

For example:

Name Randy
Address 10 Apple Road
City Anytown
State CA
Zip 90001

Would become:
Name Address City State Zip
Randy 10 Apple Road Anytown CA 90001

I've been wondering this for years!!

Thanks,

Edward

[Anne Troy]

Copy--> then Edit-->Paste special-->Transpose
You may need to paste it to a new worksheet.
************
Anne Troy
www.OfficeArticles.com

"Edward Chambers" <EdwardChambers@discussions.microsoft.com> wrote in
message news:D7018BFE-7633-479B-987E-FFA47F76DBA1@microsoft.com...
> Does anyone know an automated way to get data that is listed in cells
> going
> down the page (vertically) into cells that go across the page
> (horizontally)?
>
> For example:
>
> Name Randy
> Address 10 Apple Road
> City Anytown
> State CA
> Zip 90001
>
> Would become:
> Name Address City State Zip
> Randy 10 Apple Road Anytown CA 90001
>
> I've been wondering this for years!!
>
> Thanks,
>
> Edward

[Edward Chambers]

Thanks to both of you, Anne and Duke.

Works like a charm -- even copies formulas correctly. I'm loving Excel
today! =)

Thanks.

"Anne Troy" wrote:

> Copy--> then Edit-->Paste special-->Transpose
> You may need to paste it to a new worksheet.
> ************
> Anne Troy
> www.OfficeArticles.com
>
> "Edward Chambers" <EdwardChambers@discussions.microsoft.com> wrote in
> message news:D7018BFE-7633-479B-987E-FFA47F76DBA1@microsoft.com...
> > Does anyone know an automated way to get data that is listed in cells
> > going
> > down the page (vertically) into cells that go across the page
> > (horizontally)?
> >
> > For example:
> >
> > Name Randy
> > Address 10 Apple Road
> > City Anytown
> > State CA
> > Zip 90001
> >
> > Would become:
> > Name Address City State Zip
> > Randy 10 Apple Road Anytown CA 90001
> >
> > I've been wondering this for years!!
> >
> > Thanks,
> >
> > Edward
>
>
>

[Duke Carey]

Have you tried to copy the data, move to an empty area of the worksheet, and
using Edit->Paste Special->Transpose?

Should do what you want.

"Edward Chambers" wrote:

> Does anyone know an automated way to get data that is listed in cells going
> down the page (vertically) into cells that go across the page (horizontally)?
>
> For example:
>
> Name Randy
> Address 10 Apple Road
> City Anytown
> State CA
> Zip 90001
>
> Would become:
> Name Address City State Zip
> Randy 10 Apple Road Anytown CA 90001
>
> I've been wondering this for years!!
>
> Thanks,
>
> Edward