How to Merge Two tables in excel

MShahid777 · #1 09-02-2018, 07:19 AM

I have two tables(Tabl_A and Table_B) in Excel as shown in the following figure. I want to merge them so that output is like the third table (Tabl_C). How can I do this??

Table_A

NumberOfSection Control_Set
1 2
2 6
3 15
_______________________

Table_B

NumberOfSections Zoo_Set

1 3
3 43
4 22

___________________
Table_C

NumberOfSections Control_Set Zoo_Set
1 2 3
2 6
3 15 43
4 22
_____________________

macropod · #2 09-02-2018, 02:43 PM

Cross-posted at:
https://www.excelguru.ca/forums/show...ables-in-excel
https://stackoverflow.com/questions/...ables-in-excel
https://www.mrexcel.com/forum/excel-...les-excel.html
For cross-posting etiquette, please read: http://www.excelguru.ca/content.php?184

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
From excel to custom Word tables	eperdos	Word Tables	5	05-28-2018 04:05 PM
Update & Unlink Specific Merge Field in Word Doc from Mail Merge - Excel VBA	RMerckling	Mail Merge	16	05-17-2018 05:19 PM
Help with Embedding Excel Tables	atljogger	PowerPoint	2	02-22-2012 09:57 AM
Excel Tables to MS Word	ripcurlksm	Word Tables	2	09-09-2011 04:59 AM
mail merge from access query or two tables	peter	Mail Merge	0	08-24-2010 05:32 PM