"metrueblood" wrote in message
...
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

Copy, Paste Special, Transpose
--
David Biddulph