title: Combine text from multiple rows into one cell based on unique text match?
body: <p>I have a table like so:</p>
  
  <p><a href="https://i.stack.imgur.com/cXVdz.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/cXVdz.png" alt="Data Set"></a></p>
  
  <p>Based on this set, I need "summary records" for each unique SKU prefix, e.g. PW0007 and PW0008 in this example). Here's an example:</p>
  
  <p><a href="https://i.stack.imgur.com/i4oqV.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/i4oqV.png" alt="Desired Result"></a>
  Just in case this is difficult to read, here's an example of one of the variation outputs (G1) above:</p>
  
  <p>sku=PW0007BG-3x6-M,color=Beige,size=3x6,finish=Matte,look=Wood,application=Wall or Floor|sku=PW0007BK-3x6-M,color=Black,size=3x6,finish=Matte,look=Wood,application=Wall or Floor|sku=PW0007RD-4x8-P,color=Red,size=4x8,finish=Polished,look=Wood,application=Wall or Floor</p>
  
  <p>One more point is that I have the SKU field broken out into its various parts on a separate sheet, such that I can easily do a UNIQUE() and get the Prefix PW0007 and PW0008 if that's the best approach. It's getting the variations for each unique SKU prefix and separating them that I can't begin to imagine. Maybe some kind of SUMPRODUCT?  </p>
  
  <p>I'd like to dream this is possible via a formula, but I'm more inclined to think I'll need some kind of script which is a whole 'nother ball of wax for me.</p>