I need some help with the following.
I need to find out a way to change an existing data structure into a new one as automated as possible.
I have several excel files with each of them thousands of lines, so i really can't do it manually.
The main change is that instead of one row per employee, the new structure needs one row per company, with the employee's added to the end of the company row.
To be more clear i will add an example excel file with OLD DATA & NEW DATA sheets.
I manually copied the data so its clear as to how it should be transformed.
Before i go ahead and loose hours on some VBA code that is never going to work i wanted to ask the experts first.
Because this is probably a 5 min job for any veteran excel vba user....