Capture cross-section data

K

kyoshirou

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!
 
T

toppers

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!
Click to expand...


try:

Select cells

Copy=>Paste Special=> Transpose
 
Top