title: Convert Vertical Data to Horizontal Data (Transpose Won't Work)
body: <p>I have a spreadsheet with the following values:</p>
  
  <pre><code>CUST_ID, NAME, PHONE, EMAIL
  0000, John Smith, 000-223-4567, test@email.com
  0000, Ed Jones, 001-323-4567, test1@email.com
  0000, Frank Dill, 002-423-4567, test2@email.com
  0001, Rich Pickle, 003-523-4567, test3@email.com
  0001, Phil Burger, 004-623-4567, test4@email.com
  0001, Brian Mac, 005-723-4567, test5@email.com
  0002, Slick Whopper, 006-823-4567, test6@email.com
  0003, Name Finger, 007-923-4567, test7@email.com
  </code></pre>
  
  <p>...</p>
  
  <p>Importing this table into Access, it would rather have it going horizontal based on CUST_ID (because of the form I have setup for the data)</p>
  
  <p>So the spreadsheet should look something like this...</p>
  
  <pre><code>CUST_ID, NAME_1, PHONE_1, EMAIL_1, NAME_2, PHONE_2, EMAIL_2, NAME_3, PHONE_3, EMAIL_3
  0000, John Smith, 000-223-4567, test@email.com, Ed Jones, 001-323-4567, test1@email.com, Frank Dill, 002-423-4567, test2@email.com
  0001, Rich Pickle, 003-523-4567, test3@email.com, Phil Burger, 004-623-4567, test4@email.com, Brian Mac, 005-723-4567, test5@email.com
  0003, Name Finger, 007-923-4567, test7@email.com
  </code></pre>
  
  <p>I already manually moved 50 of them using copy and paste method, but there are 150 more to do, and this way is very time consuming. The paste special, transpose method doesn't work because when you do that the matrix looks like this...(per CUST_ID)</p>
  
  <pre><code>CUST_ID, N_1, P_1, E_1                    N_1, N_2, N_3
  CUST_ID, N_2, P_2, E_2     --------&gt;      P_1, P_2, P_3
  CUST_ID, N_3, P_2, E_3                    E_1, E_2, P_3
  </code></pre>
  
  <p>I need it to look like this...</p>
  
  <pre><code>CUST_ID, N_1, P_1, E_1, N_2, P_2, E_2, N_3, P_3, E_3
  </code></pre>