Dependent Dropdown list With Filter Function

Hello everyone,

I have been trying to create a database that includes dependent dropdown lists from a set of data. The data that I have consists of 2 columns vendors & merchandise. 
Column A | Column B

A.                Apple

A.                Orange

B                 Pen

C                 PC

C                 Laptop

where column A is the vendor list, and column B show the merchandise which the vendor sells.

In the database, I have a list that shows the 3 vendors above (A, B, C). I need another dependent dropdown list that shows the merchandises in column B depending on the vendor. So, if I choose A, Apple and orange will show up only. I tried to use filter, and it works fine but the issue is that I can use it only if I have one row not multiple ones. I tried to use Xlookup but it doesn't return a list/array. 

the row data cannot be modified otherwise I would have used offset and changed the list of vendors to column headers.