Thank you Frans. Great idea about converting to CSV. we import now using excel, I could even just remove the table format and try it that way. I’ll ha...
Mynda and Catalin, thank you so much for your responses. not sure why I didn't think of it but you guys are on point. Thanks, Karen
Hi Mynda, Thank you. I'm excited to learn PQ and its potential to improve processes. Along with concatenate, I'll need TEXT to put zeros in front i...
Hi Mynda, Thank you for your help. I was able to write 4 macros that get me to my desired results which will work in the interim. Having said that,...
Hi Mynda, thank you so much for doing this. Not quite sure how to work with it now but I managed to changed the file path of Sample File. Not sure ...
Hi Mynda, You're the best, thank you so much for your help. I added some dummy data. There shouldn't be any duplicated information (CN may du...