title: How to convert a multi line excel cell to multi row while keeping other values the same?
body: <p>How can I convert a multi line cell to a multi row while keeping the data in other cells the same.
  Here is what I have and the desired result is shown below as well. 
  Tried text to column but it converts it to multi column which is not what I am looking for. Here is what I have with over 100 rows.</p>
  
  <p><a href="https://i.stack.imgur.com/8xT20.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/8xT20.png" alt="Current spreadsheet with over 100 rows"></a></p>
  
  <p>Here is what the it should look like.</p>
  
  <p><a href="https://i.stack.imgur.com/EuSfd.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/EuSfd.png" alt="enter image description here"></a></p>
  
  <p>Any help would be appreciated..</p>