Sorting List by Sublist value


#1

Hello. I have an excel read that I’m trying to sort into two or more categories based on a sublist value. Is there a way I can use ‘GroupByKey’ to do so?

For instance, I have a list of 6 items, each with 4 sublist items. How could I split that list using a value from their sublists? (in the attached image, sorting the list into two categories, one for “one user” and the other for “multiple user”)

Capture

I hope this is clear, I’m at a loss for a better explanation.


#2

How about this?

List by Sublist Contains

or this…

List By Sublist Index Value


#3

Hi Ben, That’s exactly what I was looking for, thanks!