Hi Below is my requirement. Can someone help me on this.
I have a raw data coming up in the below format (only column 2). I have added the 1st column for understanding purpose only and is not part of raw data file.
RawData.JPG
I would like to have a VBA code to change the RawData to the below format.
output.JPG
The challenging part is A single person can have 1 or more jobs and each job will follow under the previous one and the Name of the person is available on top of the 1st job.
Bookmarks