Multiple data tables on one Excel Sheet

[NielBerg]

Hi Guys,

Really need your help with the following:

I have an Excel sheet that contains multiple tables per division. The tables for each division vary in size in terms of the number of rows. The columns are however consistent throughout.

In column A, a division's name appears followed by the column headings starting in column B in the next row. I need to write a script to consolidate the data from all tables (divisions) without having to manually manipulate the Excel file.

I am totally stumped and would appreciate any help I can find. I've attached an example of the file with dummy data.

Hope you can help me.

Cheers,

Niel

[trdandamudi · Accepted solution]

Please see the attached file and this is one way of doing. I just loaded one file and hope this is what you want.

[NielBerg]

Dear Trdandamudi,

This is exactly what I was looking for.

Thank you so much for your kind assistance.

I really appreciate it.

Regards,

[trdandamudi]

You are welcome and good to know that it helped.