New column with grouped concatenated values

[sujimon]

Hi,

I am trying to get Column4 auto calculated added based the values in column1/2 and 3. Value in column4 is the concatenated values of column1/2/3 for all values of column1.

Column1 Column2 Column3 Column4
AAA TEST1 10 AAA TEST1 10 TEST 2 15 TEST3 20
AAA TEST2 15 AAA TEST1 10 TEST 2 15 TEST3 20
AAA TEST3 20 AAA TEST1 10 TEST 2 15 TEST3 20
BBB TEST1 11 BBB TEST1 11 TEST2 12 TEST6 10
BBB TEST2 12 BBB TEST1 11 TEST2 12 TEST6 10
BBB TEST6 10 BBB TEST1 11 TEST2 12 TEST6 10
CCC TEST1 6 CCC TEST1 6 TEST3 4 TEST4 4
DDD TEST3 4 DDD TEST1 6 TEST3 4 TEST4 4
DDD TEST4 4 DDD TEST1 6 TEST3 4 TEST4 4


Thanks
Suji

[Pepe Le Mokko]

Administrative Note:

Welcome to the forum.

Unfortunately, this is a duplicate thread, and you are allowed only ONE thread per issue here.

Please see Forum Rule #5 about thread duplication.

I am closing this thread, but you may continue here in the original thread: https://www.excelforum.com/excel-for...ml#post5197308