|
|
 |
| Author |
Message |
tongcc8
|
 Posted: Tue Mar 01 11:06:06 CST 2005 |
Top |
Excel Misc >> Table Layout Question
I have a table that i need into a different layout..
For example:
Name Henry Sally Fran Mark Jared
House # 2 6 9 7 3
House style A B C D E
Porch Y Y N Y Y
Fence N N Y N N
Dog/Cat Dog Dog Cat Cat Dog
I want to lay it out like so:
Name House # House style Porch Fence Dog/Cat
Henry
Sally
Fran Data from each individual is dropped into the
correct place
Mark
Jared
Can any one please advise me on doing this simply, rather than cut 'n paste?
Thanks so much for your assistance!!! Have a great day! mary true****
Excel179
|
| |
|
| |
|
David
|
| Posted: Tue Mar 01 11:06:06 CST 2005 |
Top |
Excel Misc >> Table Layout Question
> I have a table that i need into a different layout..
> For example:
>
> Name Henry Sally Fran Mark Jared
> House # 2 6 9 7 3
> House style A B C D E
> Porch Y Y N Y Y
> Fence N N Y N N
> Dog/Cat Dog Dog Cat Cat Dog
>
> I want to lay it out like so:
> Name House # House style Porch Fence Dog/Cat
> Henry
> Sally
> Fran Data from each individual is dropped into the
> correct place
> Mark
> Jared
>
> Can any one please advise me on doing this simply, rather than cut 'n
paste?
> Thanks so much for your assistance!!! Have a great day! mary true****
Copy, Paste Special, Transpose
--
David Biddulph
|
| |
|
| |
|
Dave
|
| Posted: Tue Mar 01 11:13:57 CST 2005 |
Top |
Excel Misc >> Table Layout Question
The answer is a cut-and-paste, but it is simple. Step one is to make a
backup copy of your data so you can recover from a disaster as
necessary. Then highlight and copy your data, select the target
location, then right click, select Paste Special, check the Transpose
checkbox, and press OK. Your X axis becomes your Y axis and vice
versa.
Dave O
|
| |
|
| |
|
| |
|