Actually power query can do more than that, so more I had transformed quite a number of tedious excel steps to PQ, including text analytics, pq M language is quite powerful and it is easier for people like me who are slow in VBA, DAX etc, as most of the steps can be done by UI just once, and subsequent just right click and refresh
If you can upload your original requirement with mock-up data ( no need many records), I can take a look on the possibility of fully automate it
Of course if you prefer VBA then other forum members can advise.
Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...