Need to Insert Text in Range

One more Note :
There are Columns, like 1 to 2, or 1 to 3, or 4 to 5 .....MAX 12
For Formula, they really DO NOT MATTER.
It matter ONLY in Final, when I will Concatenate, or ...Textjoin ...all corresponded columns.
Like I will have 20 charts, for 20 Wi, I look in all 20 for Column 1, and join in main chart

Also it can be like this, per column
- Write Wi in first column (in row, number,gap)
- Shift Wi in second column at Pitch
- Take all and Index (number, pitch)

I have simplified my request, see attached.
Only ONE W1 to insert, only 2 columns.
To be more simple :
In Column 1 , add W1 - at Cluster Number times at Gap (0,1,2....).
Then in Column 1 copy ALL above at Index Number times at Index Pitch
In Column 2, just copy Column 1,at Index Pitch
Column 2 is identical with column 1 but "shifted down" with Index Pitch

This is from Post#3
But I don't get how you count index for column 2

O4 or V4

Formula:

Please Login or Register  to view this content.

Yes, you right, but I was was trying to make as simple as possible (so I took second column off), hopping for other ideas for one column.
So could you please think the Formula this way too :
1. Formula just for First Column (regardless of c4 or d4 value) : add W1, at E4, G4 times, at H4 gap, with I4, then index it J4 times at K4 Pitch with L4
2. Formula in Second Column : just Copy Column 1, down, F4 Pitch
So second column of W1 (if d4<>0 and f4<>0) , it is identical with first but down F4 (and First column take care for all)
Then I will concatenate all per corresponded C4 and D4
if D4 = 0 (w1 stay in one column) then nothing in second column

please see attached, there is no need for Right copy formula

Please try

R4
=REPT($B$4,SUMPRODUCT(($N4=MOD(ROW(INDIRECT("1:"&$G$4))*(1+$H$4)-$H$4+$E$4-2,$N$3)+1)*($C$4=R$3)*($I$4="y")))

T4
=REPT($B$4,SUMPRODUCT(($N4=MOD(ROW(INDIRECT("1:"&$G$4))*(1+$H$4)-$H$4+COLUMN(INDIRECT("C1:C"&$J$4-1,))*$K$4+$E$4-2,$N$3)+1)*($C$4=T$3)*($L$4="y")))

$C$4=R$3 for check if From Column (C4) match column header (R3)

=mod(24,24)=0 but we need 24

=Mod(24-1,24)+1
=24

that is -1


Then we need to add From row (E4) that make another -1

=Mod(24-1+E4-1,24)+1
=Mod(24+E4-2,24)+1

Yes, the reason i was asking you is this :
On first Index, one -1 is from MOD and another -1 is from E4, so -2
On second Index, there is E4+F4 ...but still -2
This drive me crazy !!! because I assigned say cell A1=-2 ( I have it 14 times X Formula so there are 28 of -2) and for some I have A1=-2 and other A1=-3

Now look like -2 work , but I do not get it why ! Who cancel + F4 ?

I have checked both MOD in formula and they work great, as it should ....

F4 is just for shift, no need another -1.

Which formula?

From R4 check I4, Index T4 check L4 as it should.