title: Combining duplicate rows and concatenating the unique field in a certain format
body: <p>I have a question that might be simple to answer, I just haven't found what I'm looking for online. Please excuse my ignorance I mostly work in access.</p>
  
  <p>I have a few hundred thousand listings of products, they're categorized by <strong>Application</strong>, <strong>Make</strong>, <strong>Model</strong>, <strong>year</strong> and <strong>part #</strong>. Now what I want to accomplish is that if Application, make, model and part # hold the same values, they get combined into the same row, and the Years get put into the format <code>YYYY-YYYY</code> (ex. 2010-2013).</p>
  
  <p>Is there any way to accomplish this with vba or a formula? ? I can clarify any confusions if I'm not making myself clear enough. </p>
  
  <p>Thank you.</p>