Unique Transpose Formula though results skip 3 cells

[ronie85]

Hi, I am using the below formula though I need the results to skip 3 cells each time, therefore the results to appear in cells A1, D1, G1, J1 etc.

=UNIQUE(TRANSPOSE(Data!I4:I13))

Can someone help please?

 

[Fluff]

Do you want to put anything in the other cells? ie B1, C1, E1 etc

 

[ronie85]

Do you want to put anything in the other cells? ie B1, C1, E1 etc

I need them cells to be blank as the data under relys on them being blank

 

[Fluff]

Ok, how about

=TOROW(EXPAND(UNIQUE(Data!I4:I13),,3,""))