I am trying to split an excel spreadsheet via a macro. The data I have is as follows in the attached document. On the original tab it shows the data and multiple cells of it on one row. Then in the final spreadsheet it shows the final output I am trying to achieve. I want to take the additional data points and copy the delivery persons main information and copy it also.
I am unsure the best way to accomplish this process. I have tried offset and other methods and just can't seem to pull this off. Any help would be great.