data extraction from a table in a particular format

[GAUTAM SINGH]

i have a two set of data in excel sheet comprises of 4 column each, i want to extract that data in one table C where row 1 of table B comes under row 1 of table A and thereon....

[TABLE="width: 896"]
<colgroup><col width="64" span="14" style="width:48pt"> </colgroup><tbody>[TR]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[TD="width: 64"][/TD]
[/TR]
[TR]
[TD="class: xl65, colspan: 4"] Table A[/TD]
[TD] [/TD]
[TD="class: xl64, colspan: 4"] Table B[/TD]
[TD][/TD]
[TD="class: xl65, colspan: 4"] Table C[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]1[/TD]
[TD="class: xl63, align: right"]2[/TD]
[TD="class: xl63, align: right"]3[/TD]
[TD="class: xl63, align: right"]4[/TD]
[TD][/TD]
[TD="class: xl63, align: right"]13[/TD]
[TD="class: xl63, align: right"]14[/TD]
[TD="class: xl63, align: right"]15[/TD]
[TD="class: xl63, align: right"]16[/TD]
[TD][/TD]
[TD="class: xl63, align: right"]1[/TD]
[TD="class: xl63, align: right"]2[/TD]
[TD="class: xl63, align: right"]3[/TD]
[TD="class: xl63, align: right"]4[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]5[/TD]
[TD="class: xl63, align: right"]6[/TD]
[TD="class: xl63, align: right"]7[/TD]
[TD="class: xl63, align: right"]8[/TD]
[TD][/TD]
[TD="class: xl63, align: right"]17[/TD]
[TD="class: xl63, align: right"]18[/TD]
[TD="class: xl63, align: right"]19[/TD]
[TD="class: xl63, align: right"]20[/TD]
[TD][/TD]
[TD="class: xl63, align: right"]13[/TD]
[TD="class: xl63, align: right"]14[/TD]
[TD="class: xl63, align: right"]15[/TD]
[TD="class: xl63, align: right"]16[/TD]
[/TR]
[TR]
[TD="class: xl63, align: right"]9[/TD]
[TD="class: xl63, align: right"]10[/TD]
[TD="class: xl63, align: right"]11[/TD]
[TD="class: xl63, align: right"]12[/TD]
[TD][/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD="class: xl63"] [/TD]
[TD][/TD]
[TD="class: xl63, align: right"]5[/TD]
[TD="class: xl63, align: right"]6[/TD]
[TD="class: xl63, align: right"]7[/TD]
[TD="class: xl63, align: right"]8[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl63, align: right"]17[/TD]
[TD="class: xl63, align: right"]18[/TD]
[TD="class: xl63, align: right"]19[/TD]
[TD="class: xl63, align: right"]20[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="class: xl63, align: right"]9[/TD]
[TD="class: xl63, align: right"]10[/TD]
[TD="class: xl63, align: right"]11[/TD]
[TD="class: xl63, align: right"]12[/TD]
[/TR]
</tbody>[/TABLE]

 

[Special-K99]

Try this

1. in the column to the right of table A put =ROW()*2 and copy down the column
2. in the column to the right of table B put =ROW()*2+1 and copy down the column
3. Copy Table B and the column to the right of B under table A
4. Sort the merged tables on the column to the right of Table A

You should now have the output as per table C

 

[GAUTAM SINGH]

matter not solved..

 

[Joe4]

Please tell us the exact ranges Tables A and B are in, and what range you want Table C created in.