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