duplicate values in 1 column combined into another column

[lab0909]

In the attachment I have duplicate values in Column A with different values in Column B. What I'm looking for is to combine the different values from Column B into 1 cell in column C. The attachment shows what result I'm looking for in Column C.

[PeteABC123]

Hi LAB:

I searched Dr. Google and came up with this result that might help you. It uses a UDF and appears to handle what you're looking for.

You might explore it, adjust your ranges. Doesn't look too messy.

https://www.get-digital-help.com/exc...into-one-cell/

Pete

[ChemistB]

In C2 copied down

Please Login or Register  to view this content.

Does that work for you?

[lab0909]

No it gave me the #NAME? result.

[FlameRetired]

TEXTJOIN isn't available in Office 2016 or older. That's why the NAME? error.

You can distribute the resulting 'User ID's' across some columns and then concatenate them by brute force in column C or you can use a user defined function (VBA).

In the attached I've done both.
1st Sheet1; in D2 filled across and down as far as needed this distributes the IDs by their 'Task Numbers'.

Please Login or Register  to view this content.

Then concatenate them as described in C2 and filled down.

Please Login or Register  to view this content.

On Sheet2 this UDF by tigeravatar has been installed.

The formula in C2 must be array entered.

If you aren’t familiar with array-entered formulas array enter means the formula must be committed from edit mode by simultaneously pressing and holding down Ctrl and Shift while hitting Enter.

This formula does what TEXTJOIN does.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

1. Copy code
2. Press Alt and F11 on your keyboard to open VB Editor
3. Click on Insert and select Module
4. Paste code into Module and close VB Editor.

Don't forget to save your worbook as Macro-Enabled workbook. (Done)