HI everybody,
I've been burning my head trying to find a solution for my problem, and not achieving to do so, I came here for your precious help!
I have one sheet in one workbook that contains the data I want to organize. In this data, I have several datasets placed horizontally, in the side of each other.
Each "dataset" correspond to a month containing daily values of several headers. So, it is organized as:
Date Header_1 Header_2 ...
01/01/1990 value value
... ... ...
31/01/1990 value value
The number of headers in each "dataset" vary, but they can or not repeat themselves in the others "datasets".
Please see the uploaded file for better understanding.
What I want to do is to organize my data chronologically into a single one database containing all information. Two things have to be done here:
1 - Some function/macro to transfer the horizontally arranged "datasets" into a one new "database" organized chronologically
2 - Some function/macro to match the headers. Ex: Dataset_2 is to be placed below dataset_1. If header_1 of "dataset_2" already exists in dataset_1, I want the values of header_1 of dataset_2 to "merge" with already existant header_1 of dataset_1.
I hope I was clear enough.
Thank you very much!
Bookmarks