Question on Iterate Column

I would unpivot all the PriceX columns, did the multiplication, and then pivoted them back.

See the example below.

multiply columns.morph (2.5 KB)
data.txt (63 Bytes)

If the table is too big to unpivot the entire table at once, you can unpivot it line by line using the technique described in my earlier answer here: