Table - Copy/Drag formulas issue with reference

[jocker_boy]

Hello,

I have a table with multiple columns.
I will try to replicate my problem with this simple table:

Data​	Col1.1​	Col1.2​	Col1.3​	Col2.1​	Col2.2​	Col2.3​
1	=[@[Data]]*10	=[@[Col1.1]]*10	=[@[Col1.2]]*100​	=[@[Data]]*20	=[@[Col1.1]]*10	=[@[Col1.2]]*10
2	=[@[Data]]*10	=[@[Col1.1]]*10	=[@[Col1.2]]*100	=[@[Data]]*20	=[@[Col1.1]]*10	=[@[Col1.2]]*10
...

When i copy the formulas from "Col1.2" to column "Col2.2", the formula is the same, but i need the formula to have a relative reference and not absolute.
When i copy the formulas from "Col1.3" to column "Col2.3", the formula is the same, but i need the formula to have a relative reference and not absolute.

I can't drag because i have columns between, right?

My goal is to obtain this:

Data	Col1.1	Col1.2	Col1.3	Col2.1	Col2.2	Col2.3
1	=[@[Data]]*10	=[@[Col1.1]]*10	=[@[Col1.2]]*100	=[@[Data]]*20	=[@[Col2.1]]*10	=[@[Col2.2]]*10
2	=[@[Data]]*10	=[@[Col1.1]]*10	=[@[Col1.2]]*100	=[@[Data]]*20	=[@[Col2.1]]*10	=[@[Col2.2]]*10
...

If it was only two columns i change the reference manually, but i have a big table with multiple columns in this situation.

How can i do it?

Thanks,
Gonçalo