title: Excel: Take data from multiple cells, convert the content into a new column
body: <p>Please see image below:</p>
  
  <p><img src="https://i.stack.imgur.com/z1vNX.gif" alt="Before"></p>
  
  <p>I have an excel sheet with 500+ products. The numbers represent various sizes available (Y=Yes). So for example, 'Product D' is available in 3mm and 12mm. Is there a formula that will take the 'Y' from the columns and convert it into mm in the sizes column, separated by a comma and space? See example below:</p>
  
  <p><img src="https://i.stack.imgur.com/UNgYv.gif" alt="After"></p>