Forum Discussion
Bad Data Pull, trying to correct by pulling select Data into a new sheet. Row Help Needed
Good morning, We purchased a new company and received a data pull from their system (Solomon) so we can add the customers into our Database (Epicor P21). I am using the =[AR_CustomerListing.xlsx]She...
MLewis72 I'd suggest you have your IT people look into PowerQuery. A tool, integrated in Excel since 2016, which is very capable of transforming "garbage" data to something useful. Exactly how is difficult to say without having the file to play with.
Riny_van_Eekelen Thank you, at this point I will try anything.
MLewis72 Please check your private messages.