macro or formula to combine duplicate records of a field by combining other field values

If the field B (is item no contains both text, string) includes 'sample' anywhere in cell value, then there should only be one line in excel file per field A value (A is also alphanumerical).
If there are duplicate values of field A, then would like to concatenate all values of field B using symbol | in a separate row.

I have tried using the IF formula, but it does not work. Please advise on the macro/formula.



Thanks

Perhaps the following will help.
1. To make a list of distinct PO numbers: =IFERROR(INDEX(A$2:A$30,MATCH(0,INDEX(COUNTIF(E$1:E1,A$2:A$30),,),)),"")
2. To make concatenate items numbers associated with each PO**: =TEXTJOIN("|",TRUE,IF(A$2:A$30=E2,B$2:B$30,""))
** Denotes an array entered formula which is not entered in the same way as a 'standard' formula. Instead of pressing just ENTER, you first hold down CTRL and SHIFT, and only then press ENTER. If you've done it correctly, you'll notice Excel puts curly brackets {} around the formula (though do not attempt to manually insert these yourself).
Let us know if you have any questions.

So...Combine...Only if duplicates have corresponding Item Numbers that contain the text "SAMPLE"
Vba Solution...

Please Login or Register  to view this content.