How to Split Alt Enter Column Data into Separate Rows with respect to Row A..

[AhmedExperts]

Hello Guys, Please help me.. I have large data in Excel sheet in following format
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]32423
2234325[/TD]
[TD]12131[/TD]
[TD]11231
2534R
323422[/TD]
[TD][/TD]
[TD]1245
224241[/TD]
[TD]112125
21212
353453
464363
545352[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]12423[/TD]
[TD]123525
22424[/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD][/TD]
[TD]114343[/TD]
[TD]12342
2E23R[/TD]
[TD]1342[/TD]
[TD]1423R
25346[/TD]
[TD]1324[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1234
2525[/TD]
[TD][/TD]
[TD]1234
2522[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I want to convert this data to this format..
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]A[/TD]
[TD]32423[/TD]
[TD]12131[/TD]
[TD]11231[/TD]
[TD][/TD]
[TD]1245[/TD]
[TD]112125[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]12423[/TD]
[TD]123525[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD]2234325[/TD]
[TD][/TD]
[TD]2534R[/TD]
[TD][/TD]
[TD]224241[/TD]
[TD]21212[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]22424[/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD][/TD]
[TD][/TD]
[TD]323422[/TD]
[TD][/TD]
[TD][/TD]
[TD]353453[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]464363[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]A[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]545352[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD][/TD]
[TD]114343[/TD]
[TD]12342[/TD]
[TD]1342[/TD]
[TD]1423R[/TD]
[TD]1324[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]1234[/TD]
[TD][/TD]
[TD]1234[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD][/TD]
[TD][/TD]
[TD]2E23R[/TD]
[TD][/TD]
[TD]25346[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]2525[/TD]
[TD][/TD]
[TD]2522[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]B[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]33452[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Please help me to convert data in above format. I want each entry in single column with First Column ,, Thanks in advance..

 

[yky]

This is an interesting problem. I'd like to know how many rows and columns are in the file.

Alternatively, if you have or have access to OmniPage, you can save the file in PDF format and have OmniPage to OCR it.

 

[Rick Rothstein]

This is an interesting problem. I'd like to know how many rows and columns are in the file.

To follow up on yky's question, I have one as well... Are the stacked values all in single normal cells or are they in a merged cells? In other words, is the first table composed of Rows 1 and 2 or are they various merged sets of cells occupying Rows 1 to 7?