Apply formula from row to column

[atifsharif]

We have two tables one is having product and its value.

Other has expected sold numbers by year

We need a final table like below, in which three columns are added as there are there years, if more years then more columns. 

Every new column is formula i.e  (Year Sold Value)*(Package Unit Value)

Anything helps, I have trying Formula and Multirow formula but not getting my desired result.

[IraWatt · Accepted solution]

Hey @atifsharif,

here's one way of achieving this:

Any questions or issues please ask :)
HTH!
Ira

[atifsharif]

Thanks, that's what I was looking for, It worked

[IraWatt]

Great ! no worries @atifsharif  😄