autofill formula?

[mjdalmalti]

i have two sheet , as you see in first sheet (sheet1) there is a column first row have a serial number and second row is type

New Microsoft Excel Worksheet.xlsx
	A
1	1234
Sheet1

i wanna separate them from each other in second sheet to look like that

New Microsoft Excel Worksheet.xlsx
	B
7
Sheet2

I tried to write this code in the first cell on the second sheet

=Sheet1!A1
=Sheet1!A3

and make auto fill but it does not work and make duplicated

 

[Joe4]

Place this in cell A1 and copy down:

=OFFSET(Sheet1!$A$1,(ROW()-1)*2,0)

Place this in cell B1 and copy down:

=OFFSET(Sheet1!$A$2,(ROW()-1)*2,0)

 

[mjdalmalti]

Place this in cell A1 and copy down:

=OFFSET(Sheet1!$A$1,(ROW()-1)*2,0)

Place this in cell B1 and copy down:

=OFFSET(Sheet1!$A$2,(ROW()-1)*2,0)

thanks for help mr Joe4

 

[Joe4]

You are welcome.