Question scores displayed in fields / rather than the selected response or the total calculation

Thanks John, I have tried this, but each question (there are 120 questions) need to go onto a new row, rather than in a new column. Each submission from Typeform will create a new worksheet in my Google Sheet. 

@JulieLaw - a possibility to create a second tab in the google sheet something like this (sort of mirrors your image):

• header row
  • column 1 header - id_num with the question numbers running down in series
  • column 2 questions - with questions 
  • column 3 - n: labels would 2,3,4,etc (once column for each response result - ok  you might have thousands of cols but.. )
• in column 3 - in the cell c2 (third column, row corresponding to the first questions) - put in a formula that does an array transpose of the ‘response data’ ie the numeric values, for the vlookup of the submission record in the corresponding rownumber, using the column header as the lookup value,  ie if the column header is 2 then get the data from row 2 on the tab where the typeform submissions are ‘dumped’, starting at the appropriate column offset, and then transpose the data to write it in the column of this second tab. 

it’s a wee bit complicated but it should work if you can figure out the transpose formula.. 

des