| makeresults
| eval _raw="apple1
apple-orange
apple-yellow
banna123
banna-red
banna-orange"
| multikv noheader=t
| table Column_1
| rename Column_1 as _raw
| rex "(?<fruit>[a-zA-Z]+)"
The rex puts the fruit into a field which you can then group by as you need
Thank you @ITWhisperer
| makeresults
| eval _raw="apple1
apple-orange
apple-yellow
banna123
banna-red
banna-orange"
| multikv noheader=t
| table Column_1
| rename Column_1 as _raw
| rex "(?<fruit>[a-zA-Z]+)"
The rex puts the fruit into a field which you can then group by as you need