How to merge 2 Excel tables?

		Microsoft Office Forums > Microsoft Excel > Excel
How to merge 2 Excel tables?

FAQ

Thread Tools

Display Modes

02-14-2020, 04:21 PM

lynn0712

Windows 7 64bit How to merge 2 Excel tables?

Office 2016

Novice

Join Date: Dec 2017

Posts: 14

How to merge 2 Excel tables?

I have 2 tables on one Excel workbook: _CustomerList and _SalesList. I created a one to many relationship between them based on a column called, Customer. How can I merge the 2 tables, with the end result being a worksheet that has columns from both tables. Examples for the tables are in the attached spreadsheet.

Example Tables.xlsx

Tags

merge tables

« Previous Thread | Next Thread »

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Nesting Tables in a Merge Document	TeresaRyanKS	Mail Merge	2	02-04-2020 12:09 PM
Populating Tables with data when available only - Using Mail merge	stevejohhnym	Mail Merge	1	06-25-2019 12:50 AM
Mail Merge does not split tables if entry has a number in front	B-Man	Mail Merge	5	05-19-2019 07:25 AM
How to Merge Two tables in excel	MShahid777	Excel	1	09-02-2018 02:43 PM
mail merge from access query or two tables	peter	Mail Merge	0	08-24-2010 05:32 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 10:22 AM.