auto increment merged column by 1

[matrix_xrs]

Hi,

is there a formula to auto increment a merged column formula by 1?

example

I have collumn A with Name:
A1: John
A2: Mary
A3: Rebecca
A4: steve
.
.
.



column E:G is merged and linked to A1
column I:K is merged and liked to A2

the problem is if i copy and past E:G to I:K and so forth I can't get excel to auto increment by 1.

attach is a sample of workbook.

any help would be greatly appreciated

[Teethless mama]

First remove merged cells.

E17: =IF(MOD(COLUMN(),4)=1,INDEX($A:$A,INT((COLUMNS($E:E)-1)/4+2)),"")

copy across

[matrix_xrs]

thank you very much that did the trick.