How to get form questions to be rows for each question

[mlowman]

I have an app that will have multiple forms based on a column value. When you select a record it uses the value  of one of the columns to present (Form A, Form B, or Form C). The user then will answer questions on each form. I am needing to have each questions that is answered as a row rather than a column. My thought is that I will have a "Question table" which will store an ID and the text values of what the questions are. Then there will be a table/sheet that will have each questions response as a row.

Any help with this would be much appreciated.