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.