copy formula horizontally

[vipasha]

Hello,
I am stuck in copying formula horizontally, here what I want to do
This is base file
[TABLE="width: 500"]
<tbody>[TR]
[TD]year 2015[/TD]
[TD]tast1[/TD]
[TD]tast2[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]10000[/TD]
[TD].2[/TD]
[TD].6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]50000[/TD]
[TD].9[/TD]
[TD].1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]40000[/TD]
[TD].5[/TD]
[TD].5[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

I want to create a file like this
[TABLE="width: 500"]
<tbody>[TR]
[TD][/TD]
[TD]dept1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]tast1[/TD]
[TD]sumproduct of year 2015 and task1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]task2[/TD]
[TD]sumproduct of year 2015 and task 2[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

So here year range will remain constant but column will change. I am not able to do it .
Please help me.

Regards,

 

[dermie_72]

if you put $ to the left of the column that you do not want to change, and leave the changing columns as is, it should fix the issue.

IE. IF you do not want column A to change, but you want column B to move right.
=column($A:$A),column(B:B).

hope that helps.