title: Convert Semicolon Separated Values to Columns - Excel
body: <p>I have a spread sheet of values organized by id number with a column of semicolon separated values.<img src="https://i.stack.imgur.com/gl656.jpg" alt="enter image description here" /></p>
  <p>I would like the spread sheet to be organized by id number with a column for each value and if that value exists for a id number a 1 be placed in the cell and if it doesn't exist a 0 placed in the cell. <img src="https://i.stack.imgur.com/OqNDV.jpg" alt="enter image description here" /></p>
  <p>Has anyone done this before or know where I should start?</p>