How to display multiple values concatinated in 1 cell without double entry of result value

[jomi9501]

Hi, again I'm asking everyone's help to provide the formula for below problem.

Criteria: Look for values that matches on column A from cell F
Result: All the values from column B will be concatinated in 1 cell after satisfying the criteria but same values at column B must not be displayed.


See attached. Expected outputs are displayed in column G, highlighted in red.


Thanks in advance.

[Marcol]

I think you mean concatenated, rather than merged, mention merging here can get some very volatile replies.

Anyhow, why do you want to do this?
It makes your data virtually useless.
Most people who have data in the form you ask for ask how to get it back to what you already have!!!

[jomi9501]

Yeah, I mean the values must be concatenated. I need all the searched values that match to criteria to display in 1 cell for ease of viewing all the related invoices.

[kvsrinivasamurthy]

In the Search data you have duplicate rows. Can those duplicate rows be deleted.