I need to do some analyses on a set of data for work and cannot figure out how to do this. I am familiar with Google Sheets
QUERY, but could not do what I want and could not find anything like it using searches in Google.
Here is a very simple data set:
Here are the desired results:
Or the list of values could be space separated. Or the list of values could have each value in a separate cell in the row. I might want to sort the values, descending numerically.
A simple query to get unique Category values:
=QUERY(UNIQUE($B$2:$B:$7), "SELECT Col1",1)
This gives me:
Any ideas or pointers would be appreciated!