I want to take a spreadsheet with almost a thousand rows similar in format to this,

`Sheet1`

Q A1 Bool A2 Bool A3 Bool Q1 Q1A1 1 Q1A2 0 Q1A3 0 Q2 Q2A1 0 Q2A2 1 Q2A3 0 Q3 Q3A1 0 Q3A2 0 Q3A3 1 Q4 Q4A1 0 Q4A2 1 Q4A3 0

and rearrange every row like this.

`Sheet2`

1 =Sheet1!A2 =Sheet1!C2 =Sheet1!B2 =Sheet1!E2 =Sheet1!D2 =Sheet1!G2 =Sheet1!F2

But if I select A1:C4 and try to use Auto Fill it will not increment the row number. It jumps from row #2 to row #6. Resulting in his:

1 =Sheet1!A2 =Sheet1!C2 =Sheet1!B2 =Sheet1!E2 =Sheet1!D2 =Sheet1!G2 =Sheet1!F2 2 =Sheet1!A6 =Sheet1!C6 =Sheet1!B6 =Sheet1!E6 =Sheet1!D6 =Sheet1!G6 =Sheet1!F6

instead of this:

1 =Sheet1!A2 =Sheet1!C2 =Sheet1!B2 =Sheet1!E2 =Sheet1!D2 =Sheet1!G2 =Sheet1!F2 2 =Sheet1!A3 =Sheet1!C3 =Sheet1!B3 =Sheet1!E3 =Sheet1!D3 =Sheet1!G3 =Sheet1!F3

I haven't found any way to bypass this or any other way of arriving to the same result. Any suggestions?