Sorting a list based on text recognition

[Cosmin88]

Hello,

I'm somewhat new to using excel / google sheets and I would need a little help from you. I need to do something in google sheets and I don't know how.

I have 3 columns that contain (the lists are much longer, but for example we use what is below):
A1 - pear
A2 - parsley
A3 - apple
A4 - carrot


B1 - fruit
B2 - vegetable
B3 - fruit
B4 - vegetable

C1 - company 1
C2 - company 2
C3 - company 1
C4 - company 3

What I have to do is generate in another sheet a list that will be filtered according to the company that delivers the products. I would like to do this without using the filter function offered by google sheets or excel.
Is there any formula to help me for this purpose?

The result I want is (in another sheet):
A1 - company 1
A2 - company 1

B1 - pear
B2 - apple

C1 - fruit
C2 - fruit

Notice that I do not want the other details in the source table to be displayed.

Thank you for your time and for your idea
All the best!

[arlu1201]

Hello Cosmin88,

Welcome to Excelforum. Be a part of large Excel community. Enjoy Learning.