Transpose 1 of 2 label columns

Question

I have a table that has 2 label columns and then a series of data columns formatted as such. And I have nearly 20,000 rows, 900+ Accounts and 16 Quarters, so serious amounts of data. Not something I want to do manually.

Name Account Q12014 Q22014 Q32014 Q42014 Q12015 Q22015 etc. A X 2 12 14 3 4 A Y 1 3 11 B X 14 32 22 1

I need to transpose the second column and the headers so that it looks like the following. And yes, if the sparse data without values goes away, that's a good thing for me. I've tried the copy/paste Transpose option and Pivot tables to no avail. Any advice? I see a lot of examples with one column, but nothing this complex.

Name Time X Y A Q12014 2 A Q22014 12 1 A Q32014 14 3 A Q42014 A Q12015 3 11 A Q22015 4 B Q12014 14 B Q22014 32 B Q32014 B Q42014 22 B Q12015 B Q22015 1