E
edwinxav
Hi there:
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
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