I have an excel dataset with 50 tabs having 48 columns in each tab. The structure of the column doesn't change but, few values of a field have a - (dash) which i think is causing an issue for Dynamic input tool. Can you please help me resolve this? I tried to build a macro but got stuck and couldn't figure out a way forward. Shall i be using a macro though for it?
Appreciate help in advance. Workflow with dummy data attached. Thanks heaps :)
