Hi;
I've got a single-column output of values in a Google sheet (the output is from a http pull so the data refreshes every day). I need to basically de-dupe the list and remove blank cells so as to have 1 column, unique values, no spaces. Does anyone know a formula that would be able to do this? Closest I have got is =unique(query(A2:A,"select A where A<>''")) but this still seems to give me a single blank value.