Auto populated sheet data from a form (zoho sheets)

Having created a form with 5 variables, I have decided I don't want the 2nd, 3rd or 4th variables anynore and have deleted them from the form, which has deleted them form the sheet. This leaves me with the 1st and what was the 5th variable on the form. In the sheet I have timestamp, user, then variable 1, then three empty cells, then variable 5. How can I tell the form to enter var5' data in the cell immediately after var1,

I have

A B C D E F G

timestamp user variable 1 variable2

I need to change it to

A B C D E F G

timestamp user variable 1 variable 2

Is there a way to 'manipulate' the data coming from the form to where it goes in the sheet?

Thanks Rich