Power Query, Transform Column by values in another columns

[Dicken]

Hi,
I've attached a work book showing in excel what I would like to do in power query,
I have a budges for each row, and want to allocate it between each item in that row, so if A1 = 3 , B1 = 2 , A1 = ( Budget / 5 ) * 3

so;

Please Login or Register  to view this content.

Gives the number of items in each cell, I can then sum these in addcolumns and divide

Please Login or Register  to view this content.

I then need to multiply this by the number in each cell by this, I hope the excel table will show exactly what I'd like to do.

I have thought about using addcolumns 'standard' multiply' ? the query accerAllocation is the one I've got furthest with so far.

Richard.

[romperstomper]

You could do something like this:

Please Login or Register  to view this content.

[Dicken]

Thanks,
I had a few failed attempts at re pivoting, as I'd only removed one column and it kept messing things up,
I shall hang on to this for future reference.
RD