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!

	A
1	name 1
2	name 2
3	name 3
4	name 4
5	name 5
6	name 6
7	name 7
8	name 8

<tbody>
</tbody>

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

<tbody>
</tbody>

 

[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)),""),"")