Hey all,
I am currently a student who is partaking in compiling my survey results.
I want to pair the variables up in a row so that i am able to see a person's data more properly as shown by the table below. Ideally this is what i want to achieve.
[TABLE="width: 356"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Question 1[/TD]
[TD]Question 2[/TD]
[TD]Question 3[/TD]
[/TR]
[TR]
[TD]Age[/TD]
[TD]Gender[/TD]
[TD]Occupation[/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD]51-60[/TD]
[TD]Male[/TD]
[TD]Businessmen[/TD]
[/TR]
[TR]
[TD]21-30[/TD]
[TD]Female[/TD]
[TD]Worker[/TD]
[/TR]
[TR]
[TD]31-40[/TD]
[TD]Male[/TD]
[TD]Housewife[/TD]
[/TR]
[TR]
[TD]21-30[/TD]
[TD]Male[/TD]
[TD]Worker[/TD]
[/TR]
[TR]
[TD]15-20[/TD]
[TD]Male[/TD]
[TD]Student[/TD]
[/TR]
[TR]
[TD]41-50[/TD]
[TD]Female[/TD]
[TD]Professional[/TD]
[/TR]
[TR]
[TD]21-30[/TD]
[TD]Female[/TD]
[TD]Professional[/TD]
[/TR]
</tbody>[/TABLE]
However, the arrangement of my current data is not what i want as the results of each person is displayed (as attached) individually and i can't compare them.
https://www.dropbox.com/s/cmwv7a7qlvnwg6w/SMARTSURVEY.xlsx
I am expecting at least 200 more respondents and i need a way to automatically arrange the data like the above table.
Any help would be greatly appreciated.
Regards
Derek
I am currently a student who is partaking in compiling my survey results.
I want to pair the variables up in a row so that i am able to see a person's data more properly as shown by the table below. Ideally this is what i want to achieve.
[TABLE="width: 356"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD]Question 1[/TD]
[TD]Question 2[/TD]
[TD]Question 3[/TD]
[/TR]
[TR]
[TD]Age[/TD]
[TD]Gender[/TD]
[TD]Occupation[/TD]
[/TR]
[TR]
[/TR]
[TR]
[TD]51-60[/TD]
[TD]Male[/TD]
[TD]Businessmen[/TD]
[/TR]
[TR]
[TD]21-30[/TD]
[TD]Female[/TD]
[TD]Worker[/TD]
[/TR]
[TR]
[TD]31-40[/TD]
[TD]Male[/TD]
[TD]Housewife[/TD]
[/TR]
[TR]
[TD]21-30[/TD]
[TD]Male[/TD]
[TD]Worker[/TD]
[/TR]
[TR]
[TD]15-20[/TD]
[TD]Male[/TD]
[TD]Student[/TD]
[/TR]
[TR]
[TD]41-50[/TD]
[TD]Female[/TD]
[TD]Professional[/TD]
[/TR]
[TR]
[TD]21-30[/TD]
[TD]Female[/TD]
[TD]Professional[/TD]
[/TR]
</tbody>[/TABLE]
However, the arrangement of my current data is not what i want as the results of each person is displayed (as attached) individually and i can't compare them.
https://www.dropbox.com/s/cmwv7a7qlvnwg6w/SMARTSURVEY.xlsx
I am expecting at least 200 more respondents and i need a way to automatically arrange the data like the above table.
Any help would be greatly appreciated.
Regards
Derek