Extracting data from a disastrous excel-style Table

[milehighfreak]

I have a friend who collected hundreds of surveys from different college dorms across the state. Instead of asking me to database it all for him, he decided to give it a shot himself. He's wound up putting everything he collected into one single table, complete with duplicate dorm names and rooms down the columns, and everything filled out sideways.



I offered to fix it but I'm stumped. The topleft table is roughly the format he's put the surveys in; the three tables on the right I created manually to try to work backwards to a solution, and the form is based on the basic query of those tables.

I want to be able to turn the table on the left into something approaching the much better setup on the right. How can I go about it without him having to type everything out again? Thanks a ton.

I'll attach that picture with a second post.

[milehighfreak]

The message you have entered is too short.

[milehighfreak]

Partially solved it myself, folks. Did it only using 2000 too. Woop woop.