PowerQuery - flatten price grid to price by dimensions

I have following “lookup table” from which I would like to have the price per cartype

So my final goal is to have a flat list based on the lookup of the table.
I am a bit puzzled how to deal with this as unpivoting the data is not really working.

Ok nevermind, I was doing my unpivoting incorrectly and also included the cartype in the unpivoting action.

So based on this info I got the correct form.

1 Like