Conditionally remove duplicates in one column

Sorry if I didn't explain it well

So you would split your query.

Query A = All of your data

Query B = Reference Query A, filter to only include those starting with #

Query C = Reference Query A, filter to only include those not starting with #, remove duplicates

Query D = Append Query B and Query C

The above could all be done in one query via the Advanced Editor, but if you prefer to do it via the GUI, just separate out the queries and to avoid them cluttering up your model, set queries A, B and C to not load (right click the query and untick Enable load)

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

Matt