Microsoft Office Forums - View Single Post - [Solved] How to merge 2 Excel tables?

Thread: [Solved] How to merge 2 Excel tables?

View Single Post

Old

02-14-2020, 04:21 PM

lynn0712

lynn0712 is offline

lynn0712 uses Windows 7 64bit

Windows 7 64bit lynn0712 uses Office 2016

lynn0712 uses Office 2016

Office 2016

Novice

The original poster

Join Date: Dec 2017

Posts: 14

lynn0712 is on a distinguished road

Default

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

Reply With Quote