Hi everyone! This is my first post on this amazing forum. Would appreciate help with an issue I’m struggling with:
I would like to display a list of things in a repeating group, where each cell will also have a repeating group containing things with similar values.
Let me further explain… So let’s say I have this data:
Number Fruit
1 Orange
1 Kiwi
2 Banana
3 Apple
4 Watermelon
4 Pear
Based on a search on this sample data, what I would like to output is a 4 cell repeating group in this structure (where the fruit will be displayed in a sub repeating group):
1 Orange
Kiwu
2 Banana
3 Apple
4 Watermelon
Pear
Tried “Grouping By” number but the result is just numbers without the rest of the data (Fruit name). Am I in the right direction at all? Help?