title: How can I iteratively transpose vertical lists to horizontal entries?
body: <p>I have a list of about 400 companies, including their addresses, phone numbers and industry categories in the following format.</p>
  
  <pre><code>Column A
  
  Prestige Automotive
  1234 Jefferson Drive
  Anywhere, TX 54321 
  Phone: 000-000-0000
  Primary Category: Manufacturing 
  Jefferson Grocery 
  4321 Washington Drive 
  Anywhere, TX 54321 
  Phone: 111-111-1111
  Primary Category: Grocers
  ...
  </code></pre>
  
  <p>I need to reformat the data so that it is listed horizontally, in the following format</p>
  
  <pre><code>Prestige Automotive|1234 Jefferson Drive|Anywhere, TX 54321|000-000-0000|Manufacturing
  
  Jefferson Grocery|4321 Washington Drive|Anywhere, TX 54321|111-111-1111
  </code></pre>
  
  <p>What would be the fastest way to do this in excel without having to manually transpose each company block? Thanks</p>