215325 Data sorting

I have a text file with a list of keywords. I need it divided into ad groups based on the common phrase. I'll provide the spreadsheet with the keywords and an example of how it should be broken out. There's 14,000 phrases in the file, and it's broken into groups of 4-5 phrases per ad group. Easy job, just boring.