title: Merge multiple values in one column into same cell
body: <p>EDIT: The intended output is to have one spreadsheet of the untouched IDs and commodity categories, and one spreadsheet with 1 occurrence of ID with the commodity categories combined. This is because I'm writing reports on total number of commodities and total number of unqiue incidents. </p>
  
  <p>I have a spreadsheet that has an ID number across multiple rows with a commodity category and what I need to do is get the commodity categories associated with that ID number into the same cell. I'm seeing a lot of stuff about INDEX/MATCH but I'm not sure how it applied to my specific example. </p>
  
  <p>Most examples are outputting data from the same column into the same row/multiple columns or something slightly different. I need to do this row about 600 rows and all have varying amount of rows and values. Some IDs have only one value, some have 40 values, and some have 2. Appreciate the help.</p>
  
  <p>The intended input/output is below.
  EX:</p>
  
  <pre><code>ID               Commodity Category
  A01-0301         Food and Beverage
  A01-0301         Apparel and Accessories
  A01-0301         Food and Beverage
  A01-0302         Other   
  
  ID               Commodity Category
  A01-0301         Food and Beverage, Apparel and Accessories, Food and Beverage
  A01-0302         Other    
  </code></pre>