Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Merging data into pivot tables | Excel Discussion (Misc queries) | |||
Merging of pivot tables | Charts and Charting in Excel | |||
Merging two tables | Excel Programming | |||
Merging 2 different pivot tables | Excel Worksheet Functions | |||
merging multiple pivot tables | Excel Worksheet Functions |