Sort by Merged Cells

Attach a workbook with some sample data, showing what you want as a result.

Go Advanced -> Manage Attachments -> Upload

Thanks again for any help.
I have attached a sample of how it should look like including merged cells with working formula.

What I am asking is to be able to sort by last column or to highlight cells based off then input of last column.

I hope this helps.