Hello Community,
I am looking for a macro (prepared and shared by someone from Alteryx community), where I can consolidate data from multiple excel sheets(Multiple Tabs, Inconsistent columns). This was available in the gallery few years back but I can't find it now. So, please help me! Any new similar macro you found in the gallery would also work.
Thanks!
Hammad
@Hammad23
This is my collection as well.
Hi @Hammad23 ,
Obviously if you have inconsistent columns you will need to do a manual mapping exercise, but I've attached the tools I published a while back to the gallery.
I've also attached an example of how they work.
I hope this helps,
M