Excel data formatting

I would like to swap the data in an Excel spreadsheet by changing the
columns to rows, and the rows to columns, For example:

This: 1 2 3 Would become this: 1 4 7
4 5 6 2
5 8
7 8 9 3
6 9

Is this possible, and if so how can I do it? I have a large amount of
data and performing this by hand would take an extreme amount of time.

Any assistance you can provide would be appreciated.




--
jreinier

Teethlessmama
Thu May 08 12:15:01 CDT 2008

Select your range > right click Copy > select your destination cell, right
click paste special > Transpose > OK out


"jreinier" wrote:

>
> I would like to swap the data in an Excel spreadsheet by changing the
> columns to rows, and the rows to columns, For example:
>
> This: 1 2 3 Would become this: 1 4 7
> 4 5 6 2
> 5 8
> 7 8 9 3
> 6 9
>
> Is this possible, and if so how can I do it? I have a large amount of
> data and performing this by hand would take an extreme amount of time.
>
> Any assistance you can provide would be appreciated.
>
>
>
>
> --
> jreinier
>

David
Thu May 08 12:37:54 CDT 2008

Have you tried either the TRANSPOSE function or Copy/Paste Special/
Transpose ?
--
David Biddulph

"jreinier" <jreinier.26903ab@officefrustration.com> wrote in message
news:jreinier.26903ab@officefrustration.com...
>
> I would like to swap the data in an Excel spreadsheet by changing the
> columns to rows, and the rows to columns, For example:
>
> This: 1 2 3 Would become this: 1 4 7
> 4 5 6 2
> 5 8
> 7 8 9 3
> 6 9
>
> Is this possible, and if so how can I do it? I have a large amount of
> data and performing this by hand would take an extreme amount of time.
>
> Any assistance you can provide would be appreciated.
>
>
>
>
> --
> jreinier

jreinier
Thu May 08 16:05:01 CDT 2008


Thanks! I really appreciate you responses. Worked great!




--
jreinier