title: How to transpose multiple cells in row to column in Excel
body: <p>I have data that looks like:</p>
  
  <pre><code>name    field1  field2  field3
  John    abc     dcf     fdd
  Sue     ddf     
  Beth    fds     rtfds   
  </code></pre>
  
  <p>And I want it to look like this:</p>
  
  <pre><code>abc     John
  dcf     John
  fdd     John
  ddf     Sue
  fds     Beth
  rtfds   Beth
  </code></pre>
  
  <p>Note the rows have variable numbers of fieldx columns... I'm trying to use a <a href="http://www.mrexcel.com/forum/excel-questions/393274-help-partial-transpose-row-copy.html" rel="nofollow">VBA script from MrExcel</a> and getting an "application defined or object defined error."</p>
  
  <p>Is there a way to do this with just an excel formula? I can post the VBA script, but if there is a formula solution that would be better.</p>