Skipping rows

[zabbadi]

Hey,

I have 2 columns of 95 cells in sheet 1. What i want is:
Sheet 1 A2 in Sheet 2 A1
Sheet 1 B2 in Sheet 2 A2
Sheet 1 A10 in Sheet 2 A3
Sheet 1 B10 in Sheet 2 A4
Sheet 1 A18 in Sheet 2 A5
Sheet 1 B18 in sheet 2 A6
and so on
As you can see it's skipping 8.
Your help is greatly appreciated!

 

[SpillerBD]

Power Query.

 

[zabbadi]

Power Query.

Thanks for the suggestion but I can't figure out a formula.. I was trying with OFFSET formula but failed miserably

 

[bbrnx19]

Book1
	A	B	C	D	E	F	G
1	sheet1						sheet2
2	A_1	b_1	2				A_1
3			2				b_1
4			10				A_2
5			10				b_2
6			18				A_3
7			18				b_3
8			26				A_4
9			26				b_4
10	A_2	b_2	34				A_5
11			34				b_5
12			42				A_6
13			42				b_6
14			50				A_7
15			50				b_7
16			58				A_8
17			58				b_8
18	A_3	b_3	66				A_9
19			66				b_9
20			74				A_10
21			74				b_10
Sheet1

Cell Formulas
Range	Formula
C4:C21	C4	=C2+8
G2,G20,G18,G16,G14,G12,G10,G8,G6,G4	G2	=INDIRECT("Sheet1!A"&Sheet1!C2)
G3,G21,G19,G17,G15,G13,G11,G9,G7,G5	G3	=INDIRECT("Sheet1!B"&Sheet1!C3)

=INDIRECT("Sheet1!"& IF(MOD(ROW(G1),2),"A","B")&Sheet1!C2)

 

[zabbadi]

Book1
	A	B	C	D	E	F	G
1	sheet1						sheet2
2	A_1	b_1	2				A_1
3			2				b_1
4			10				A_2
5			10				b_2
6			18				A_3
7			18				b_3
8			26				A_4
9			26				b_4
10	A_2	b_2	34				A_5
11			34				b_5
12			42				A_6
13			42				b_6
14			50				A_7
15			50				b_7
16			58				A_8
17			58				b_8
18	A_3	b_3	66				A_9
19			66				b_9
20			74				A_10
21			74				b_10
Sheet1

Cell Formulas
Range	Formula
C4:C21	C4	=C2+8
G2,G20,G18,G16,G14,G12,G10,G8,G6,G4	G2	=INDIRECT("Sheet1!A"&Sheet1!C2)
G3,G21,G19,G17,G15,G13,G11,G9,G7,G5	G3	=INDIRECT("Sheet1!B"&Sheet1!C3)

=INDIRECT("Sheet1!"& IF(MOD(ROW(G1),2),"A","B")&Sheet1!C2)

Thank you! This seems like what I'm looking for but I'm new to this forum so I have a few questions.
Is the formula I need INDIRECT("Sheet1!"& IF(MOD(ROW(G1),2),"A","B")&Sheet1!C2) or the one I can copy from cell G2?
Either way, I tried both of them and they wont work for some reason.. Maybe because I'm using Office 365?

 

[zabbadi]

It works on the same sheet. I'll just write a formula on another sheet to copy the cells I want in order.
Thank you very much!