View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
edwinxav edwinxav is offline
external usenet poster
 
Posts: 1
Default 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