CONCATENATE Based On Condition

[DeepMa1]

Hi All,

Need your help to get Formula or Macro.

I have data in Column A,B & C as below
A B C
ValueLK Check Update
A+Z+B Z 1, 2, 3
A+Y+B Y 4, 5
A+X+B X 8, 9, 10
A+C+B+Z Z 1, 2, 3, 4
B+X X 7, 3, 4, 1, 2, 3

It should check for the character in B column if exists then print output in D column as below

Output
A+Z+B+1
A+Z+B+2
A+Z+B+3
A+Y+B+4
A+Y+B+5
A+X+B+8
A+X+B+9
A+X+B+10
A+C+B+Z+1
A+C+B+Z+2
A+C+B+Z+3
A+C+B+Z+4
B+X+7
B+X+3
B+X+4
B+X+1
B+X+2
B+X+3

PFA excel sample FYR

TIA

[MarvinP]

Hi DeepMa,

If you had version 365 of Excel and the newer functions, you could do this answer in a single cell. The formula would be:

Please Login or Register  to view this content.

VStack Transpose TextSplit.xlsx

Verity that you are still using version 2016 and keep asking.

[DeepMa1]

Thanks MarvinP for your swift response, but if i have more that 1000 i need to keep update the formula appending the cell info. Is there any other way to do this