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 A		Table B		Table C
1	2	3	4		13	14	15	16		1	2	3	4
5	6	7	8		17	18	19	20		13	14	15	16
9	10	11	12							5	6	7	8
										17	18	19	20
										9	10	11	12

<colgroup><col width="64" span="14" style="width:48pt"> </colgroup><tbody>
</tbody>

 

[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.