Vba to reorder data while preserving subscript format. Anybody please ?

[Ombir]

Hi friends,

I am trying to reorder set of data which is shown below:

Input data is in Col A:

[TABLE="width: 798"]
<tbody>[TR]
[TD]1. A patient who is being mechanically ventilated has increased physiological dead space.[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]What is the most likely relationship to be present in the capilliaries that perfuse the alveoli that are part of the physiological dead space?[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]A. P_Alv > P_PA > P_PV[/TD]
[/TR]
[TR]
[TD]B. P_Alv > P_PV > P_PA[/TD]
[/TR]
[TR]
[TD]C. P_PA > P_Alv > P_PV[/TD]
[/TR]
[TR]
[TD]D. P_PA > P_PV > P_Alv[/TD]
[/TR]
[TR]
[TD]E. P_PV > P_Alv > P_PA[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]2. Non-alcoholic fatty liver disease:[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]A. accounts for 20% of abnormal LFT's when other known causes of liver disease have been excluded[/TD]
[/TR]
[TR]
[TD]B. affects about 50% of the morbidly obese, about 20% of the obese and 3% of lean persons[/TD]
[/TR]
[TR]
[TD]C. affects obese and/or diabetic women, and has a benign outlook[/TD]
[/TR]
[TR]
[TD]D. is frequently symptomatic, with hepatomegaly in about one-quarter of cases[/TD]
[/TR]
[TR]
[TD]E. liver biopsy is the only certain way of making the diagnosis and would be usually indicated[/TD]
[/TR]
</tbody>[/TABLE]


The output structure should be as shown below:

Output Data is in Col A-G:

[TABLE="width: 1046"]
<tbody>[TR]
[TD]Qno.[/TD]
[TD]Question[/TD]
[TD]Opt1[/TD]
[TD]Opt2[/TD]
[TD]Opt3[/TD]
[TD]Opt4[/TD]
[TD]Opt5[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]A patient who is being mechanically ventilated has increased physiological dead space. What is the most likely relationship to be present in the capilliaries that perfuse the alveoli that are part of the physiological dead space?[/TD]
[TD]P_Alv > P_PA > P_PV[/TD]
[TD]P_Alv > P_PV > P_PA[/TD]
[TD]P_PA > P_Alv > P_PV[/TD]
[TD]P_PA > P_PV > P_Alv[/TD]
[TD]P_PV > P_Alv > P_PA[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]Non-alcoholic fatty liver disease:[/TD]
[TD]accounts for 20% of abnormal LFT's when other known causes of liver disease have been excluded[/TD]
[TD]affects about 50% of the morbidly obese, about 20% of the obese and 3% of lean persons[/TD]
[TD]affects obese and/or diabetic women, and has a benign outlook[/TD]
[TD]is frequently symptomatic, with hepatomegaly in about one-quarter of cases[/TD]
[TD]liver biopsy is the only certain way of making the diagnosis and would be usually indicated[/TD]
[/TR]
</tbody>[/TABLE]



Subscript format must be preserved while converting to output format. Please help with some vba code to reorder this data. Thanks.