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

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

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,094
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,241
Messages
5,449,199
Members
405,556
Latest member
dougbohr

This Week's Hot Topics

Top