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:
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD]type A
[/TD]
[TD]type A
[/TD]
[TD]type B
[/TD]
[/TR]
[TR]
[TD]ID
[/TD]
[TD]name
[/TD]
[TD]Q1
[/TD]
[TD]Q2
[/TD]
[TD]Q3
[/TD]
[/TR]
[TR]
[TD]1
[/TD]
[TD]name 1
[/TD]
[TD]text 1-1
[/TD]
[TD]text 1-2
[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]2
[/TD]
[TD][/TD]
[TD]text 2-1
[/TD]
[TD][/TD]
[TD]text 2-3
[/TD]
[/TR]
[TR]
[TD]3
[/TD]
[TD]name 2
[/TD]
[TD]text 3-1
[/TD]
[TD]text 3-2
[/TD]
[TD]text 3-3
[/TD]
[/TR]
[TR]
[TD]4
[/TD]
[TD]name 3
[/TD]
[TD][/TD]
[TD]text 4-2
[/TD]
[TD]text 4-3
[/TD]
[/TR]
</tbody>[/TABLE]

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