convert column with variable records to rows where last field identified by a string

Data looks like this. The only thing that is consistant is that the revenue field always exists and always ends 'mil)' Other fields may be missing but have inconsistant clues as to content. eg company may contain 'plc' but may not
If all 5 fields are present the data needs to become a row with 5 columns = Job Company Addr Industry Revenue
If not we can place the revenue in the correct column and paste whatever other fields exist in columns counting back from the 'mil)' defining the last
This may not be perfect but it would allow me to interpret the data

Job
Company
Addr
Industry
Revenue mil)
ABCD Holdings plc
8 Square
Banking
79,881.0 (USD mil)
Director E-Business
XYZ plc
123 STREET
Retail
267.0 (USD mil)
some company
an address
on line retailer
3.0 (USD mil)
another company
Banking
200.0 (USD mil)