title: Mapping text in one column to text in other column
body: <p>I have a csv with a column containing titles in various forms. I need to map all ceo, chief operating officer, coo, cmo, etc. to 'C-Level'; vp, svp, vice president to 'vp-svp' in another column. </p>
  
  <p>I have tried mapping titles with numbers but wasn't able to do so, and also think there might be an easier way to do so. I also want to do them all in one column, rather than having 2 columns for C-Level and VP-SVP when mapping them.</p>
  
  <p>Attached is the expected result.</p>
  
  <p>How do I solve the problem?</p>
  
  <p><a href="https://i.stack.imgur.com/qrfXX.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/qrfXX.png" alt="enter image description here"></a></p>