Grouping data from multiple lists?

Need help Database
1

Hey Guys,

Lets say I have 2 lists -
List 1 has:

  • apple
  • banana
  • orange

List 2 has:

  • apple
  • banana
  • Pear

I have a repeating group let’s say that is searching for fruits but I only want 1 of each to be displayed. When I group by Fruit, the RG seems to show the list but content is empty.

Anyone know how to sort this?

2

Sorted it - added unique elements to the end of the search! :ok_hand: