title: Excel Converting rows to columns with groups
body: <p>Let's say that I have my columns in excel set up like this:</p>
  
  <pre>Name     A    B    C    D  
  George   10   5    4    6</pre>
  
  <p>And I want it to instead be like this:</p>
  
  <pre>Name   Category   Amount  
  George     A        10  
  George     B         5  
  George     C         4  
  George     D         6</pre>
  
  <p>Is there an easy way to do a copy and paste with transpose, or with a pivot table, or does it have to be done with VBA? I've been trying to only do it with VBA but I havent gotten very far.</p>