Sort table

[cristit]

Hello,
I have a survey which returns answers as comments (as text). Each answer is made by people how have specific atributes (resulted in specific columns).
Example:

		type A	type A	type B
ID	name	Q1	Q2	Q3
1	name 1	text 1-1	text 1-2
2		text 2-1		text 2-3
3	name 2	text 3-1	text 3-2	text 3-3
4	name 3		text 4-2	text 4-3

<tbody>
</tbody>

Respondents answer to some questions, not all.
I need to do:
- 1 column with all answers (ignoring blank) from multiple columns
- next column to show respondent ID, name
- next column show the name of the question
- next column show the Type group from where the question is.

I mention that the table is quite large (300 rows of respondents; ~200 questions for each one)

Thanks for all your help