Interview Q- Need to convert XL row into coloum

Hi Team, in One interview i got one Question there have one Report and in that report they customer or candidate has given Ans. In the Interview Q xlsx there is coloum “Questionnaire” , now in “Questionnaire” column there are 3 or 5 main questions, this main question is further divided into sub Questions and the Candidate had ans those sub-question. Those Sub Questions should be in Columns and their ans should be in rows.

For better understanding i have given eg below

Uploading the Report
Interview Q.xlsx (22.5 KB)
ReportFilter.xlsx (78.3 KB)

Interview Q is the report and we need to convert in to ReporFilter