In what format do you want the output?
how many rows do you have?
if not many and
if all you want is a space between the models
=if(A1=Car,B1&" ","")&if(A2=Car,B2&" ",""& ...
or set up a helper column (C) with
=if(A1=car,B1&" ","")

copy down

then = concatinate(C:C)
the more complicated the format, the more complicated the formula.


"nandkishor" wrote:

hi,

i would like to have filtered output in concatenate, i don't know how i can
do this :(

col A has make of Car's and col B has Models and i would like to
concatenanate all the filtered models in one cell of col C.

i am stuck with this.