Hello,
I`m new here so apologies if I`m missing anything in the explanation
I have a dataset that shows to which vacancy(ies) a candidate has applied for. The problem is that I have a row for each candidate, but the last 3 columns (I-K) contain comma-separated values related to the vacancies (Vacancies to which they have applied, Date of application and Current Stage). If for example someone has applied to 3 different vacancies I want to have 3 rows with the candidate details (Columns A-H) and the details for each vacancy in each row.
If first row is:
Name ... Sourced by Vacancies Vacancies Date Vacancies Stage Tom ... Mark Vac1, Vac2, Vac 3 5/6/20,2/5/20,6/4/20 PRO,PRO,PRO
I want it to breakdown as follows:
Name ... Sourced by Vacancies Vacancies Date Vacancies Stage Tom ... Mark Vac1 5/6/20 PRO Tom ... Mark Vac2 2/5/20 PRO Tom ... Mark Vac 3 6/4/20 PRO
What I currently have is this. I`m looking for help on how to transpose the information to the newly created rows. If there is a more efficient way of doing this please let me know, I`m still starting with VBA. Thanks in advance!
Please Login or Register to view this content.
Please Login or Register to view this content.
Many thanks!
Edu
Bookmarks