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!
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.