CHANGING THE DISTRIBUTIONS OF THE INFORMATION
 

Hi the
I received a worksheet with data from a survey in this format:

SURVEY 1 2 3
4
--------------------------------------------------------------
AGE 10-15 1
16-20 1
20-30 1

NEWSPAPER
HOY 1
TIMES 1 1
OTHER


I would like to change the data something like this:

AGE NEWSPAPER
---------------------------------------
10-15 TIMES
16-20 HOY
20-30 TIMES

Does anybody knows an easy way to do this?
Thanks

EDWINXAV