Conditional reset of INDEX SMALL IF function to start with first result again

Hi there!

I have been pondering for some time about a problem I cannot seem to solve on my own. I use a INDEX SMALL IF function to produce multiple values from a table, which works fine (e.g. which fruits does Tom sell, results: apple, banana, cherry).
Now, I have other names below Tom (using the same output table), where the fomula should work in the same way (e.g., which fruits does Michael sell, results: banana, papaya) and gather information from the same table.

The problem is, that the content in the table which is searched will change (e.g. Tom only sells apples and bananas, but no cherries anymore). Therefore, the output table will change in length (Tom only needs two rows instead of three), and the whole output table moves up by one row.

How can I modify the INDEX SMALL IF functions, so that it starts again with the first result for a new name (e.g., Michael). If I just copy it down, it will look for the nth result (e.g., 4th result after Toms results are there). I want it to restart at the first result (i.e. 1:1) for a certain condition (e.g., new name on the left).

Can someone help me with this? This would be really great!

Best,
Max

Thanks for your reply!

Actually, I am trying to construct a INDEX SMALL IF formula which I can copy down for the whole column. This formula should produce multiple results (e.g., 1-3) for one criteria (e.g., "Tom" referenced from the left) and then start again with result 1 once the criteria on the left changes (e.g., the formula now looks for "Michael" instead of "Tom"). If I just change the criteria on the left then the formula will look for the 4th result for the new criteria "Michael", since the copying of the formula increases the ROW(1:1), which indicates the 1st, 2nd, 3rd, ... result, right?