A simple? autofill question

i have a set of questionnaire questions and answers one below the other on an excel worksheet (c. 200 sets of c. 100 data items). by chance each set is 100 rows long. i wish to extract the actual anwers (which are 1 or 0) into a simple table.

i set out 3 rows of cells referenced directly to the original data (sorry no vert line on my keyboard...)
=c3 \ =d3 \ =c6 \ =d6 \ =e6 etc.
=c103 \ =d103 \ =c106 \ =d106 \ =e106 etc.
=c203 \ =d203 \ =c206 \ =d206 \ =e206 etc.

I then thought I could autofill for the other 200+ rows, but exel instead restarts

=c6 etc.
=c106 etc.
=c206 etc.

Is there any way of making it continue
=c303
=c403
etc.

It seems so simple and I never thought it might not work.

Thanks for any help.