title: How to convert vertical list of data into horizontal in Excel
body: <p>I'm trying to export contacts from my dad's old Nokia phone into an iPhone. Their old software Nokia PC Suite can export those contacts into CSV and into pure text which is formatted like this:  </p>
  
  <pre><code>First Name: ...
  Last Name: ...
  Phone: ...
  
  First Name: ...
  Last Name: ...
  Phone: ...
  
  ...
  </code></pre>
  
  <p>Note#1: Sometimes there isn't <em>first name</em>, just <em>last</em> and <em>phone number</em>. They are spaced out with line break.</p>
  
  <p>The problem with CSV is that the encoding is messed up and I can't find out what it is. I would like to know how can I export the contacts into the CSV or even vCard from this pure text.</p>
  
  <p>Expected result:</p>
  
  <pre><code>First Name | Last Name | Phone
  FirstName1 | LastName1 | #####1
  FirstName2 | LastName2 | #####2
  FirstName3 | LastName3 | #####3
  </code></pre>
  
  <p><strong>edit</strong>: Note #2: There are over 600 contacts.<br>
  <strong>edit#2</strong>: 
  <img src="https://i.stack.imgur.com/U12vI.jpg" alt="">'
  Here's an example. Left side is source, right side is how I need it for the CSV file. BTW don't mind those "A"s, it's just a priority thing that my father uses...</p>