Google Sheets, Sorting not working as intended due to some unknown reason-CodePudding

I'm currently doing a spreadsheet to record form responses from google forms and then I'm moving the data through queries into a separate sheet for clarity. As you can see from the link below, My data moves over perfectly although if I try and sort the range (Z-A) based on the C column ("Taglia"). The sorting just goes wrong and the data ends up all over the place for no reason. It is due to the formula i put in the C column which essentially gathers information from the spreadsheet "Form Responses 1"?

update:

delete everything and use this in A1:

={SPLIT(" ×Nominativo×Modello×Taglia×Colore Abbigliamento×Colore Serigrafia×Tipo di Spedizione×Nome e Cognome×Indirizzo e Numero Civico×Cap×Città×Nazione×Numero Di Cellulare", "×"); 
 INDEX(QUERY({IFERROR('Form responses 1'!B2:B100/0), 'Form responses 1'!B2:C100, 
 BYROW('Form responses 1'!D2:AN100, LAMBDA(x, TEXTJOIN(", ", 1, 
 FILTER(x, REGEXMATCH('Form responses 1'!D1:AN1, "Taglia"))))), 
 BYROW('Form responses 1'!D2:AN100, LAMBDA(x, TEXTJOIN(", ", 1, 
 FILTER(x, NOT(REGEXMATCH('Form responses 1'!D1:AN1, "Taglia")))))), 
 'Form responses 1'!AO2:AV100}, "where Col2 is not null", ))}

then create a filter:

and make sure A1 is not included:

now you can sort it as you wish