Good evening.
I would like to try to combine totally different tables that will eventually be present in the various files contained in a single folder. The table that will be created will consist of all the different headers, of all the files in the folder.
Regarding the tables, it should be noted that:
1) files may not contain tables;
2) the title of the columns may not match;
3) the tables could have a different size.
The main problem will be to identify, within each file, the presence of tables (set of data sorted by rows and columns).
Basically the table that will be formed will consist of the column headers of all the files taken only once and the data of each table of files to be merged.
I note that I posted a similar request in other forums of which only one user has given me directions.
example of excel file contained in a folder:
https://www.dropbox.com/sh/7mugjqjdx...Em_htv0na?dl=0
links of posts from other forums:
CHANDOO:
https://chandoo.org/forum/threads/qu...-tables.39044/
MREXCEL:
https://www.mrexcel.com/forum/power-...bles-addition- plain-text-precedes-follows-tables.html
Thank you
Bookmarks