Remove "almost" Duplicates


I’m trying to write a Query to remove duplicates but my rows are not completely identical. The identifying duplication is in the asset name column or I could filter where column A is empty. Attached is an image of the dataset. Any suggestions to query properly in Sheetgo?


I actually solved this myself - used select A,B,C,D,E where A is not null


@lisaahagin glad you found a solution. Thanks for sharing!