I made a Spreadsheet to link with a form, but the form responses are added automatically with a horizontal header on the top. I want a vertical header on the left, so I created another sheet and used the formula ='Form Responses 1'!## to copy data from the form responses sheet to the new sheet. But when I try to autofill each row, it doesn't follow the order I want. I need it to fill like this:

='Form Responses 1'!A2 | ='Form Responses 1'!A3 | ='Form Responses 1'!A4

But it fills like this instead:

='Form Responses 1'!A2 | ='Form Responses 1'!B2 | ='Form Responses 1'!C2    

What can I do to autofill my formula correctly across 30+ columns on each of my 7 rows?

1 Answer 1


It looks like you want to transpose columns into rows. This is what the transpose formula is for. In cell A1 of the second sheet, enter

=transpose('Form Responses 1'!A:Z)

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.