Hi, I can help answer your question.
There are a couple of ways to filter or remove duplicate rows, it does involve using the filtering feature in Excel.
Follow the steps in this link to remove / filter the duplicate rows: https://support.office.com/en-us/article/Filter-for-unique-values-or-remove-duplicate-values-ccf664b0-81d6-449b-bbe1-8daaec1e83c2
Sorry to hear that the filtering did not work.
Unfortunately, The filtering does not resolve formatting.
Please let me know if you need additional help and rate my answer based on your satisfaction. Thank you.