Displaying selected rows in excel report

[Johnsos]

I want to generate a spreadsheet report from a list I have in Excel.
This is easy enough, but I only want to have items listed if every field on the row is unique which I can do, but is it possible to only display these unique lines and have any lines that contain a duplicate not be shown as a blank or anything else?

Thanks.

[Mallycat]

What do you mean "shown as a blank"? How can you show something g as blank if it is not blank?

Take a look at data\filter\advanced filter and look at the "show unique values" option