Transpose Information across rows to columns

[kirandhawan]

I am having a file which has thousands of test cases in below format:

[TABLE="class: grid, width: 1332"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 4"]Test Case Proj-10079: <IE11> Sample Test One
[/TD]
[/TR]
[TR]
[TD="colspan: 4"]Summary:[/TD]
[/TR]
[TR]
[TD="colspan: 4"] [/TD]
[/TR]
[TR]
[TD="colspan: 4"]Report Profile - Field level validations - Report list filter by window
[/TD]
[/TR]
[TR]
[TD="colspan: 4"]Preconditions:[/TD]
[/TR]
[TR]
[TD="colspan: 4"] [/TD]
[/TR]
[TR]
[TD="colspan: 4"]1. The application should be up and running[/TD]
[/TR]
[TR]
[TD="colspan: 4"]2. User with appropriate rights should be logged in to the application[/TD]
[/TR]
[TR]
[TD="colspan: 4"]3. Navigation to below path is successful:[/TD]
[/TR]
[TR]
[TD="colspan: 4"]Client >> Client Profile[/TD]
[/TR]
[TR]
[TD="colspan: 4"] [/TD]
[/TR]
[TR]
[TD="colspan: 4"] [/TD]
[/TR]
[TR]
[TD]#:[/TD]
[TD]Step actions:[/TD]
[TD]Expected Results:[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]Verify and Validate step 1[/TD]
[TD]Expected result for step 1[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]Verify and Validate step 2[/TD]
[TD]Expected result for step 2[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]Verify and validate step 3[/TD]
[TD]Expected result for step 3[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Execution type:[/TD]
[TD="colspan: 3"]Manual[/TD]
[/TR]
[TR]
[TD]Priority:[/TD]
[TD="colspan: 3"]Medium[/TD]
[/TR]
[TR]
[TD="colspan: 4"] [/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 4"]Test Case Proj-10080: <IE11> Sample Test Two[/TD]
[/TR]
[TR]
[TD="colspan: 4"]Summary:[/TD]
[/TR]
[TR]
[TD="colspan: 4"] [/TD]
[/TR]
[TR]
[TD="colspan: 4"]To Verify Report Profile - Field level validations - Report list[/TD]
[/TR]
[TR]
[TD="colspan: 4"]Preconditions:[/TD]
[/TR]
[TR]
[TD="colspan: 4"] [/TD]
[/TR]
[TR]
[TD="colspan: 4"]1. The application should be up and running[/TD]
[/TR]
[TR]
[TD="colspan: 4"]2. User with appropriate rights should be logged in to the application[/TD]
[/TR]
[TR]
[TD="colspan: 4"]3. Navigation to below path is successful:[/TD]
[/TR]
[TR]
[TD="colspan: 4"] [/TD]
[/TR]
[TR]
[TD="colspan: 4"] [/TD]
[/TR]
[TR]
[TD]#:[/TD]
[TD]Step actions:
[/TD]
[TD]Expected Results:[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]1
[/TD]
[TD]Verify step-1[/TD]
[TD]The list should display different report profiles and their details such as :[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]a) Profile Name[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]b) Report [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]c) Module [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]d) Status[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]as per the entered filter criterion.[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]2
[/TD]
[TD]Verifiy Step-2[/TD]
[TD]Expected result for step-2[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]3
[/TD]
[TD]Verifiy Step-3[/TD]
[TD]Expected result for step-3[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]4
[/TD]
[TD]Verify Step-4[/TD]
[TD]Expected result for step-4[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]Verify Step-5[/TD]
[TD]Expected result for step-5[/TD]
[TD] [/TD]
[/TR]
[TR]
[TD]Execution type:[/TD]
[TD="colspan: 3"]Manual[/TD]
[/TR]
[TR]
[TD]Priority:[/TD]
[TD="colspan: 3"]Medium
[/TD]
[/TR]
[TR]
[TD="colspan: 4"]
[/TD]
[/TR]
</tbody>[/TABLE]


Now I want to convert this into following format:

[TABLE="class: grid, width: 1446"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Test Case Name
[/TD]
[TD]Summary
[/TD]
[TD]Precondition[/TD]
[TD]Test Step #:[/TD]
[TD]Step actions:[/TD]
[TD]Expected Results:[/TD]
[TD]Execution Type[/TD]
[TD]Priority[/TD]
[/TR]
[TR]
[TD]Test Case Proj-10079: <IE11> Sample Test One[/TD]
[TD]Report Profile - Field level validations - Report list filter by window
[/TD]
[TD]1. The application should be up and running[/TD]
[TD]1[/TD]
[TD]Verify and Validate step 1[/TD]
[TD]Expected result for step 1[/TD]
[TD]Manual[/TD]
[TD]Medium[/TD]
[/TR]
[TR]
[TD]Test Case Proj-10079: <IE11> Sample Test One[/TD]
[TD]Report Profile - Field level validations - Report list filter by window[/TD]
[TD]2. User with appropriate rights should be logged in to the application[/TD]
[TD]2[/TD]
[TD]Verify and Validate step 2[/TD]
[TD]Expected result for step 2[/TD]
[TD]Manual[/TD]
[TD]Medium[/TD]
[/TR]
[TR]
[TD]Test Case Proj-10079: <IE11> Sample Test One[/TD]
[TD]Report Profile - Field level validations - Report list filter by window[/TD]
[TD]3. Navigation to below path is successful:[/TD]
[TD]3[/TD]
[TD]Verify and validate step 3[/TD]
[TD]Expected result for step 3[/TD]
[TD]Manual[/TD]
[TD]Medium[/TD]
[/TR]
[TR]
[TD]Test Case Proj-10079: <IE11> Sample Test One[/TD]
[TD]Report Profile - Field level validations - Report list filter by window[/TD]
[TD]Client >> Client Profile[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD]Manual[/TD]
[TD]Medium[/TD]
[/TR]
[TR]
[TD]Test Case Proj-10080: <IE11> Sample Test Two[/TD]
[TD]To Verify Report Profile - Field level validations - Report list
[/TD]
[TD]1. The application should be up and running[/TD]
[TD]1[/TD]
[TD]Verify step-1[/TD]
[TD]The list should display different report profiles and their details such as :

a) Profile Name
b) Report
c) Module
d) Status
as per the entered filter criterion.[/TD]
[TD]Manual[/TD]
[TD]Medium[/TD]
[/TR]
[TR]
[TD]Test Case Proj-10080: <IE11> Sample Test Two
[/TD]
[TD]To Verify Report Profile - Field level validations - Report list[/TD]
[TD]2. User with appropriate rights should be logged in to the application[/TD]
[TD]2[/TD]
[TD]Verify step-2[/TD]
[TD]Expected result for step-2[/TD]
[TD]Manual[/TD]
[TD]Medium[/TD]
[/TR]
[TR]
[TD]Test Case Proj-10080: <IE11> Sample Test Two[/TD]
[TD]To Verify Report Profile - Field level validations - Report list[/TD]
[TD]3. Navigation to below path is successful:[/TD]
[TD]3[/TD]
[TD]Verify step-3[/TD]
[TD]Expected result for step-3[/TD]
[TD]Manual[/TD]
[TD]Medium[/TD]
[/TR]
[TR]
[TD]Test Case Proj-10080: <IE11> Sample Test Two[/TD]
[TD]To Verify Report Profile - Field level validations - Report list[/TD]
[TD] [/TD]
[TD]4[/TD]
[TD]Verify step-4[/TD]
[TD]Expected result for step-4[/TD]
[TD]Manual[/TD]
[TD]Medium[/TD]
[/TR]
[TR]
[TD]Test Case Proj-10080: <IE11> Sample Test Two[/TD]
[TD]To Verify Report Profile - Field level validations - Report list[/TD]
[TD]
[/TD]
[TD]5
[/TD]
[TD]Verify step-5
[/TD]
[TD]Expected result for step-5[/TD]
[TD]Manual[/TD]
[TD]Medium[/TD]
[/TR]
</tbody>[/TABLE]

One of the most toughest and seemingly impossible scenario which I have ever come across until now!!!

Any help/pointers will be highly appreciated!!