[Vince]

Once you do get on to Power Query though, you should be able to have a set-up similar to my drainage one e.g. you could have a mark-up for a standard water main, then another one with a different symbol at the end to represent a gate valve.

The Subject or a custom column would be used to record these details.

Power query would then generate the necessary output details for your pricing software.