data extraction from a table in a particular format

GAUTAM SINGH

New Member
Joined
Dec 24, 2016
Messages
21
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
1234131415161234
56781718192013141516
9101112 5678
17181920
9101112

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

Some videos you may like

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

Special-K99

Well-known Member
Joined
Nov 7, 2006
Messages
8,341
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
 

Joe4

MrExcel MVP, Junior Admin
Joined
Aug 1, 2002
Messages
53,101
Office Version
365
Platform
Windows
Please tell us the exact ranges Tables A and B are in, and what range you want Table C created in.
 

Watch MrExcel Video

Forum statistics

Threads
1,096,358
Messages
5,449,972
Members
405,580
Latest member
MRJT

This Week's Hot Topics

Top