Convert three columns with repeating rows into a primary key, field columns, and associated rows?

Thanks HotChilli! (and Daniel as well. Ultimately the command is doing the same thing),

That's exactly what I needed. Can't show you the entirety of the end result, but here's a snippet: 

That leaves me with a quick f/u question that's much lower stakes :-): 

Now, I've got a few options for the last step: I'd like to be able to alias the fields using the lookup table included in the XML (but loaded separately...the folks who built these XML files had some interesting ideas...). So here's what I've got planned: 

1. Merge the lookup table with the Question/Answer table, then delete the original question field leaving only the aliased headings (once I pivot out that field). 
2. Leave the three final tables as is (Question/Answer, Demographics, Comments), relate them by the newly unique survey ID, and then pull them into Visualizations/tables as needed Or...
3. Merge all three tables leaving one particularly wide table with all the questions, answers, and comments in a single table. 

Using method 2 or 3 will yield the same final result, but thinking of the end users, which of these two is likely to yield better performance? I'm unfortunately in a situation where the end users "want to keep their options open" for final visualizations, so I don't have any idea what sort of dashboards they're going to have us cook up, and which fields are or aren't particularly important. 

Thanks again, this was incredibly key! 

-Snacks