I was wondering if it is possible to sort at an excel spreadsheet in a unique way.
I have an imported table it contains a list of all jobs that are run on this system. I have a start job and an end job. I need to workout the workflow from the start job to the end job.
The start job is WWPDPCW01D and the end job is WWPDPCWCMD
The spreadsheet contains Job name and its PreReq_job_name ie its previous job.
The only problem is there are multiple jobs which are PreReq but not all point back to the first job. I have tried to work on this and have hit a blank as to how to approach this.
I have attached the spreadsheet to this post.
Any guidance or assistance would be of great help