Hi,

I am trying to concatenate cells after checking the condition. For example

A B
1 0
1 A
1 B
2 0
2 1
2 B

I would like to check the value of A and concatenate B. For A = 1, I am
looking for 0 A B. For A = 2, I am looking for 0 1 B.

Is there a function to do it automatic?

Thanks