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!