Thread: Table Merging
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
jvbelg jvbelg is offline
external usenet poster
 
Posts: 8
Default Table Merging

Table1 has part #s A01, A02, A06 and related pricing of $12.50, $1.23,
and $7.48.
Table2 has part #s A02, A06, A10, A15 and pricing of $8.05, $2.03,
$5.17, $6.20

How can I merge these two tables to wind up with a combined table that
looks like this:

Part # Price 1 Price 2
--------- ------------ ------------
A01 12.50
A02 1.23 8.05
A06 7.48 2.03
A10 5.17
A15 6.20

Thanks in advance!