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!

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