How to concatenate the value of a column when all other columns are equal?

**danilom** · 05-15-2019, 11:17 AM

Current:

0001 | AA | Manoel

0001 | AA | Maria

0001 | AA | John

0006 | BB | Peter

0008 | DD | Carlos

Staying like this:

0001 | AA | Manoel; Maria ; John

0006 | BB | Peter

0008 | DD | Carlos

**Special-K** · 05-15-2019, 11:24 AM

Prob best done via VBA and not a formula unless you can use TEXTJOIN (Office 365)

How to concatenate the value of a column when all other columns are equal?

LinkBack

Thread Tools

Rate This Thread

Display

How to concatenate the value of a column when all other columns are equal?

Re: How to concatenate the value of a column when all other columns are equal?

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Concatenate cells in 3 columns if value in question is found in another column

[SOLVED] CONCATENATE a column with values equal to X

Concatenate multiple columns into a last column

[SOLVED] Concatenate row data in columns B-F based on duplicate value in column A

[SOLVED] Match cells in 2 columns and return third column value if equal

[SOLVED] Concatenate 3 columns but triggered when data is placed in a different column

if two columns hav the same number, I want them to equal the characters in the next column

Bookmarks

Bookmarks

Posting Permissions