Does anyone know of any functionality in Excel to easily identify and remove duplicated lines in a data table?

I have a buggy reporting system which we are due to replace but in the meantime I am stuck with it as the development is focused on the new system. It produces reports with rows which are duplicates of other rows, so I need to get rid of these before I can use it to produce useful information.

Thanks

Simon