I have a list of contacts. Each row contains the company name and associated information then the name and information about the first executive, then the 2nd executive, etc. some records in the actual data set can have up to 7 executives.
I want to reorganize it so that each executive is in its own row. So, in the 2nd row, the company information needs to be copied down then executive 2 needs to be listed. In the 3rd row the company information needs to be copied down and then executive 3 etc.
My original data set has 765 rows (companies).
I've attached a sample excel workbook (with fake data) with what my original data looks like (tab 1) and what my final data needs to look like (tab 2).
Any help would be appreciated.
Sample-Data-Set-Shailesh.xlsm
Bookmarks