Sorting by more than one column using GROUPCONCAT2 followers
I'm trying to find a way to group by one column, and concatenating all the values in another column, all while trying to sort by two other columns. Something like this:
GroupByColumn | SortingColumn1 | SortingColumn2 | GroupConcatValuesColumn
When I create the new sheet, I want to have only the GroupByColumn and GroupConcatValuesColumn, but sort the latter by both SortingColumns1 and 2. I tried doing this:
GROUPCONCAT(#GroupConcatValuesColumn; [#SortingColumn1, #SortingColumn2]), because I know you can provide something to sort by as the second parameter in GROUPCONCAT. This returns this error:
failed with IllegalStateException: datameer.com.google.common.collect.Iterables$8 cannot be cast to java.lang.Comparable
Is there another way that I can accomplish this? Do I need to specify something else?