Are you able to post a screenshot or the Excel file?
Unfortunately i can't share the data as it's for a client so confidential.
Not sure if this helps but the original data has 436 columns/questions along the top. When i use the reshape tool it works for nearly 300 of the columns but then just misses the last 150 to reshape so doesn't appear in the new reshaped dataset. Wondered if it only worked with a certain number of columns?