Apply formula from row to column

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.

Accepted answers

here's one way of achieving this:

Any questions or issues please ask
HTH!
Ira

here's one way of achieving this:

Any questions or issues please ask
HTH!
Ira

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

Great ! no worries @atifsharif 😄