VBA to split lines based on fields in table

[Tom123456]

Hi OBP,

Thanks for looking into this - attached is the database with the new columns i added.

The structure of the input & output tables will always be identical if this makes the VBA any easier to implement.

Cheers,
Tom