Hi @Brain , thanks for trying out the Rule Engine (Multi Column Dictionary) component. Are you able to upload the other excel used in your demo workflow (pivot2.xlsx) ?
Actually, I think I see what the problem is.
In the rules, you have TRUE => $C1$ in multiple places. (And likewise for the other columns). As the component simply relays all the rules for each column in turn to the Rule Engine, the Rule Engine is encountering the TRUE => statement and therefore subsequent rules for that column will always be ignored.
If I filter your rules xlsx for just column C1, this is the set of rules being passed to Rule Engine for that column:
If you were to manually replicate that exact set of rules in a (single) Rule Engine, which is what the component is doing on your behalf, you would see the same behaviour. So what you need to do is lose all but the last TRUE => statement for each column, and then it should work as you want it to.
You could, for example just place all the TRUE => statements at the end, so your rules list would look like this:
Give that a try and see if it now works for you 
edit:
For anybody else interested in this component, here is the original forum post from which it originated, which contains a link to the component on the community hub