title: Excel: Find unique values from a row and create a column for it?
body: <p>I am not sure if we can do this in excel. I have a spreadsheetA of about 1000 rows like this:   </p>
  
  <pre><code>Col 1      Col 2  
  Fruit1      (Apple, Banana, Grape, Orange)  
  Fruit2      (Apple, Orange)  
  Fruit3     (Grape, Banana, Orange)  
  Fruit4     (Pineapple)  
  </code></pre>
  
  <p>What I want to do? This: </p>
  
  <pre><code>Col1        Apple Banana Grape Orange Pineapple  
  Fruit1      yes   yes    yes   yes    no  
  Fruit2      yes   no     no    yes    no  
  Fruit3      no    yes    yes   yes    no  
  Fruit4      no    no     no    no     yes  
  </code></pre>
  
  <p>Problem: Column 2 has fruit names. Find unique fruit names first for each row and create a column based on unique values found. Also, if the value repeats, add yes/no for the respective row in which the value was found again. So I need to split values into column and have a counter for each time value repeats. I have to create spreadsheetB from spreadsheetA. In the example, Apple, Banana, Grape, Orange and Pineapple became unique column names and I checked yes or no for each row if the value was found.      </p>
  
  <p>I need help in this, its been 2 days already but I could not come up with an excel solution. Python solution is easy but I cannot use programming.   </p>
  
  <p>I am very sorry, my format game is not strong on Stackoverflow.    </p>
  
  <p>Thanks! :)     </p>