Hi @mp23 Thank you for the added context and details!
Can you share a screen shot of the transformer you are running?
It sounds like the issues is in the table's rendering of the data, but that should be something that we can fix.
Using a code block in a transformer or JS Query, once you grab the part of the table.data which contains the list of options in the dropdown then you can alter the data.
Map over each of the company names until you find the matching data for the 01 company name string. You should then be able to replace/reassign this value to a string that is formatted without a space between.
Changing it from "01 Solar Company" to '01 SolarCompany'. If that still does not work we can file a bug report to our engineering team to figure out why only that option is being changed and reformatted.
Also we can better help to debug this during our office hours as well! Check them out here.