Formula to copy a product list across in increments

[The_Snook]

Evening all,

I have a list of products that I want to copy into every third cell of a block of four, across a range.

I've attached an example of the data I'm working with.

Thanks in advance,

Snook

[Bo_Ry]

Please try at G6

=IF(MOD(COLUMNS($G6:G6),4)=3,INDEX($H$3:$L$3,ROUNDUP(COLUMNS($G6:G6)/4,)),"")

[The_Snook]

Bang on the money, cheers Bo_Ry!

For info - I also wrapped the formula in the T function to return blank rather than 0 when the range extends beyond the size of the product list. Fluff13 told me that tip and I absolutely love it.

Snook