Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 trueblood |
#2
|
|||
|
|||
"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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
table | Excel Worksheet Functions | |||
keep pivot table layout | Excel Worksheet Functions | |||
Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question | Charts and Charting in Excel | |||
Data Table Question | Charts and Charting in Excel | |||
pivot table question, sum fields? | Excel Worksheet Functions |