I have a tab in Google sheets with vehicle data coming from a google form. I made another tab to filter these data using a data validation. The validations are Car 1, Car 2, Car 3, Truck 1, Truck 2, Truck 3.
This works perfectly. I’d like to know if I can add “Car” to the list which would pull Car 1, Car 2 and Car 3 at the same time.
Is it possible?
Here is a test sheet showing the process and the expected outcome (LINK)

I have a sheet that looks like this:

I’m creating a range of data using the following formula, and it works just fine without the FILTER part: