I've a CSV (Tab) file which has loads of lines.

Each line should always begin with a GUID; aa5aad3a-e05a-4230-8aa1-9a039b0c32fb (random example, but always in format 8-4-4-4-12)

and

Each line always ends in Note (case sensitive).


However, some of the data has split over lines and is generally broken.

Is there a way to create a rule to make sure all those spreading over multiple lines are merged into one line, based on the fact they begin with a GUID and end with Note?

My data skills are zip.