Is there a way to get the result from the Example sheet Columns J:K using a single function?
I.e. is there a way to count unique / disctinct values within QUERY function, or any other single function that would create a pivot-like set of data with two columns?
In the example sheet I have a set of data, which I need to group by one column and count unique values in the other one. There's a workaround there, but it involves two formulas plus another one that would sort it properly (data set is growing and rows get added, so sorting manually is not the best option).
Query function (or, my knowledge of Query function) doesn't seem to be able to count unique values, so it's not working. Googling hasn't helped me much with this.