Merging Tables
Hi all,
I know theres a simple way of doing this but I just can't seem to figure it out. I have two tables. Part | Owner | Quantity A | Paul | 2 A | James | 3 A | John | 4 B | Paul | 1 B | Mike | 6 C | Sean | 3 C | Paul | 2 C | John | 4 Part | Origin A | Nebraska A | Ohio B | California B | Nevada B | Florida C | Nebraska C | Ohio I want to get these two tables merged to look like Part | Owner | Qty | Origin A | Paul | 2 | Nebraska A | James | 3 | Ohio A | John | 4 B | Paul | 1 | California B | Mike | 6 | Nevada | | | Florida C | Sean | 3 | Nebraska C | Paul | 2 | Ohio C | John | 4 I know theres a simple way to do it but I can't seem to figure it out. |
All times are GMT +1. The time now is 07:17 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com