Batch Macro for One file that contains duplicate columns?

[kkkim]

Hi, Everyone!

I am looking for some help with batch macro. Wondering if attached can be made into a macro. Basically, it's one file that contains extracts of multiple tables. I need to consolidate all the tables and transpose the data into one table containing multiple values. 

To achieve this, I used unique tool to filter columns (since same column headers are used for all tables), and repeat transpose for each then union them... 

Wanted to know if there is a more efficient way of doing this.

Thank you!

[SPetrie]

Glad its working. If you could make it as solved I would appreciate it. That way others with similar requests may be able to find it easier.