Removing unwanted columns from a combined data

karizze_fitzgeraldine

Hi, I am basically on a dead-end now and I need your help.

I am currently working on cleaning up a file that contains 1 or more tables in it.My problem is on removing the unwanted columns on each of the table so that I can align the column names on both tables. The column names that will remain will be based on a static data per 'Client Name".

I am also doing this in a macro because there will be multiple files that will feed to this workflow and the column names for each of the file will be based on the "Client Name" as mentioned.

Attached is my sample and expected output.

How do I remove the unwanted to columns and base the remaining ones to a static data?

I hope this is clear. thank you.

FileQuery.xlsx

CoG

There would need to be some structure that you could exploit as to what is an extra column. That being said, you could also change the macro settings to Auto-Configure by column name, which should fix the problem for you entirely, without needing to dynamically select columns.