Populate Excel Spreadsheet from columns of data

I have two columns of data in an excel spreadsheet. The first column contains job names, the second column contains jobs which have to have finished before the job name in column A can start. The jobs in the first column can appear in the second column as in other rows. Consequently, there are relationships that can be deduced from the data. I would like to populate the another spreadsheet using this data and show process flows of jobs through the data. In order to do this I would look to use different columns to show the dependency in a job. If a job has any jobs that must be finished first, these must be listed in column A (for example) and then the actual job itself must be listed in column B. As more records are processed it will be possible to add the new job based on the fact that either it or its associated jobs are already shown on the spreadsheet. In this way a process is being created. It is important to note that as data is added to the excel spreadsheet only the columns are being used to show that there are dependencies between them. Data will not be aligned via rows (there is a second project from this to highlight paths through the data but suffice to say that there is no requirement to align jobs and dependent jobs horizontally through rows, only columns. There are business rules on how the data should be populated which I'll go through with the successful programmer.