I need help to create a sheet for a game. I am providing the INPUT, and I would like to create the OUTPUT in another tab (do not consider the colors, its just for ease of understanding):
Mainly, the INPUT will be many locations with different items and each item with a % chance of being dropped in that location.
The OUTPUT need to be a summary of each item (only once and ordered by Item name, if possible) showing the location with the higher drop chance.
Is this possible?
If no, how could I change my INPUT to achieve an OUTPUT like this?