Table Layout Question

M

metrueblood

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 trueblood
 
D

David Biddulph

metrueblood said:
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 trueblood
Click to expand...

Copy, Paste Special, Transpose
 
D

Dave O

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
 
Top