| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Capture cross-section data
Is me again. haha..
i have a question on this: A B C D spiderman xmen batman BasketBall yes Soccer yes yes yes Swimming no how do i actually capture the 3 uers data into a new worksheet? such that i have a table called user BasketBall Soccer Swimming spiderman yes yes xmen yes no batman yes hope the table is clear.. i hate to draw here since i cant use any features.. can only use real life lettering to present. thanks! |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Capture cross-section data
On Jun 6, 2:16 am, kyoshirou
wrote: Is me again. haha.. i have a question on this: A B C D spiderman xmen batman BasketBall yes Soccer yes yes yes Swimming no how do i actually capture the 3 uers data into a new worksheet? such that i have a table called user BasketBall Soccer Swimming spiderman yes yes xmen yes no batman yes hope the table is clear.. i hate to draw here since i cant use any features.. can only use real life lettering to present. thanks! try: Select cells Copy=Paste Special= Transpose |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Capture RS232 data | Links and Linking in Excel | |||
| How do I create a cross section between two columns? | Excel Worksheet Functions | |||
| Calculate areas from a cross section chart?? | Charts and Charting in Excel | |||
| Formula to capture historical data from data that changes daily | Excel Discussion (Misc queries) | |||
| Formula to capture historical data from data that changes daily | Excel Worksheet Functions | |||
Linear Mode
