Extract Data from inconsistent number of rows

The attached data is what our Tracking System exports for items that have to be washed for a second time.

I have been asked to see whether we can compile a report from this data in a relatively simple way.

I want to be able to extract the following data:

Accountable Operator
Date Raised
Time Raised
Description (See lines H20 - H28)
Description (See line E11) where there is no line similar to Row 19

I imagine it will have something to do with whenever the Log Number changes, or something of that ilk, so was wondering if someone was able to point me in the right direction