I've done something stupid.

I've created and filled in about 30 questionnaire sheets, each on a seperate
identical worksheet. The questions run down the sheets. The easiest way I
can think of to analyse the results is to compile them on one page, one row
for every sheet (with questions along the top) and then use the auto filter.

Here's the tricky bit. I can't find a way to transpose the cell contents
from downwards on each sheet to across on the summary page. I know I can do
it cell by cell but I don't think I'll live that long.

It'll be too late to transpose each sheet by hand now - too much legwork.