Tough one! Return values of a list, but skip a row in the return sheet each time?!?!

[woodywoop]

So I have an export table of data, I can't change this, so the formulas in the second sheet all relate to looking up data from the first.

I need to somehow get the data from the first table below (on sheet one, without altering it at all)
On to the second table below, on sheet 2 (without macros), and make it look like it does in the table. having a blank space between each returned value!

[TABLE="width: 200"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]name 1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]name 2[/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]name 3[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]name 4[/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]name 5[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]name 6[/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]name 7[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]name 8[/TD]
[/TR]
</tbody>[/TABLE]

[TABLE="width: 250"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]name 1[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]name 2[/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]name 3[/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]name 4[/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]9[/TD]
[TD]name 5[/TD]
[/TR]
[TR]
[TD]10[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]11[/TD]
[TD]name 6[/TD]
[/TR]
[TR]
[TD]12[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]13[/TD]
[TD]name 7[/TD]
[/TR]
[TR]
[TD]14[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]15[/TD]
[TD]name 8[/TD]
[/TR]
[TR]
[TD]16[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[FormR]

Hi, welcome to MrExcel!

Here is one option you can try, formula in A2 is copied down as required.

Excel 2013
	A
1	Header
2	name 1
3
4	name 2
5
6	name 3
7
8	name 4
9
10	name 5
11
12	name 6
13
14	name 7
15
16	name 8
Sheet2

Cell Formulas
Range	Formula
A2	=IF(MOD(ROWS($A$2:A2),2),INDEX(Sheet1!$A$2:$A$10000,(ROWS($A$2:A2)+1)/2)&"","")

Sheet1:

Excel 2013
	A
1	Header
2	name 1
3	name 2
4	name 3
5	name 4
6	name 5
7	name 6
8	name 7
9	name 8
Sheet1

 

[steve the fish]

Hi. This works but somehow it looks like there may be easier ways:

=IFERROR(IF(MOD(ROWS($A$1:A1),2)<>0,INDEX(Sheet1!$A$1:$A$8,ROUNDUP(ROWS($A$1:A1)/2,0)),""),"")