Forum Discussion
Populating an existing Excel spreadsheet with results from a MS Forms quiz/form
In any case you need to map people names and questions text in report sheet and in forms sheet if they are not exactly the same. Most probably not. That could be done automatically if you have some logic behind.
With that we may use lookup functions (XLOOKUP, INDEX/MATCH, etc) in report sheet to pickup the answers from the form sheet.
The rest depends on details. Is form returns answers on automatically updated Excel file on SharePoint/OneDrive; or you download that file from the Forms. Does the person could fill the form multiple times or only once. Is the same form for series of answers (e.g. this quarter, next quarter, etc) or the form is used only once for the concrete assessment.
Preparations could be done in separate sheet of the report file, for example using Power Query to get data from the form file.
Afraid can't be more concrete based on information provided.