Excel to text output

[whitefeather]

Dear All,

I have a worksheet like this-

[TABLE="class: tableizer-table"]
<tbody>[TR="class: tableizer-firstrow"]
[TH]TYPE[/TH]
[TH]NAME[/TH]
[/TR]
[TR]
[TD]A[/TD]
[TD]Rachell Rivard[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Fatimah Tay[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Zane Crowley[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]Hermine Elsner[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Leigh Ortez[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Priscilla Michie[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Ken Cardiel[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD]Mack Zheng[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]Ruthe Lanz[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]Neida Gallivan[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]Sherry Barrientez[/TD]
[/TR]
[TR]
[TD]C[/TD]
[TD]Sondra Schrage[/TD]
[/TR]
</tbody>[/TABLE]

Now, I intend to generate individual text files which file name will be based on the contents of the 1st column and every text file will contain contents from the 2nd column for each respective value of the 1st column. For example, there will be 3 text files generated from the table above namely 'A', 'B' and 'C'; 'A' file will contain-
[TABLE="width: 113"]
<colgroup><col></colgroup><tbody>[TR]
[TD]Rachell Rivard[/TD]
[/TR]
[TR]
[TD]Fatimah Tay[/TD]
[/TR]
[TR]
[TD]Zane Crowley[/TD]
[/TR]
[TR]
[TD]Hermine Elsner[/TD]
[/TR]
</tbody>[/TABLE]

Expecting your help in this regard, thanks in advance.