I have the following tables with two columns
Look at the second last and third last rows, see how the right column has values 
I want to remove all rows within the table that have that value 
My main objectives is to sort the table by the right column, however, i cannot because it errors "Some cells in X contain non-scalar values and cannot be sorted."
So i'm thinking if i can remove all rows of data that have the values , then i can sort it.
Please inform how I can do this