Hello gurus,

Here's my setup. In the row of a revenue table I have:

(commas are new columns)
Name, Jan, Feb, Mar, Apr, etc
John, 0, 200, 50, 622, etc

Elsewhere, I have:

Business Unit, John
BU1, 20%
BU2, 50%
BU3, 30%

I want to create a table that allocates the data in the first table
based on the percentages in the second:
John, Jan, Feb, Mar, etc
BU1, 0, 40, 10, etc
BU2, 0, 100, 25, etc
BU3, 0, 60, 15, etc

Any suggestions on an array formula that can do this? Thanks.