I download data from one system, import it into Excel and run a number of macros over it to get it into a format I can send out for review. One of the macros looks for the beginning of the data and the end of the data, copies it and transposes it into Sheet 2. However, the macro only looks for one instance of 'Assigned unit' and in some instances there are two instances of it. When a second instance of 'Assigned unit' is found it is treated as the start of the next block of data.
I have included an example of the data I use as well as the macro.