How do I change the table layout in the view responses tables. I want to data to be filled in vertically not horizontally.
You can't change the layout of the responses table. Try opening the Detail view, via the View > Detail View menuitem, to have a row in the table presented vertically for display/editing.
So are you saying that you can not view the information in an excel speadsheet vertically? Say I have 5 rows on my form. Each row has name, address, phone number for 5 different people. I can only view this information as if it is all one piece (one person) of information instead of 5 different pieces (people) of information?