Access 365
Need a table that looks like this....
Table has several questions, answers and comments in each record.
RecordID123, Question1, Answer1, Comment1, Question2, Answer2, Comment2 and so on.....
To look like this...
Multiple same ID with each set of question, answer and comment...