title: Excel, combining 2 tables
body: <p>thank you in advance for taking time to look at this.</p>
  
  <p>I am trying to merge / combine 2 tables in excel;-</p>
  
  <p>the 1st table contains sales info of items sold in the month, there may multiple sales of same item sold on different dates.
  the 2nd table contains bill of materials for each item. 
  the common factor between the 2 tables being an item code.</p>
  
  <p>What I would like to see is a combination of the 2 tables, for each of the items sold in table, listed underneath it are the bill of materials.</p>
  
  <p>I have tried to upload a picture - shown below this text</p>
  
  <p><img src="https://i.stack.imgur.com/FR6Bq.png" alt="please see image for how i want to how to combine to tables in excel"></p>