alternate autofill number in column and next row

[sk3pt]

Hello,

Please help to autofill a range of number in an alternate column then next row with blank rows in between.
Just like this screenshot in this link:

https://drive.google.com/file/d/18DnV6diWgjRvnz4kURV7whOgF7Z13mzO/view?usp=sharing

Thanks in advance!

 

[Yongle]

Welcome to the forum

Start with values like in sheet below
Select Green cells and drag down

Excel 2016 (Windows) 32 bit

	A​	B​	C​	D​	E​	F​
1​				​	​	​
2​				​	​	​
3​				1​	​	2​
4​				​	​	​
5​				​	​	​
6​				3​	​	4​
7​
8​
9​

Sheet: Sheet1

Result is

Excel 2016 (Windows) 32 bit

	A​	B​	C​	D​	E​	F​
1​				​	​	​
2​				​	​	​
3​				1​	​	2​
4​				​	​	​
5​				​	​	​
6​				3​	​	4​
7​				​	​	​
8​				​	​	​
9​				5​	​	6​
10​				​	​	​
11​				​	​	​
12​				7​	​	8​
13​				​	​	​
14​				​	​	​
15​				9​	​	10​
16​				​	​	​
17​				​	​	​
18​				11​	​	12​
19​				​	​	​
20​				​	​	​

Sheet: Sheet1