I have the following problem and need someone to help me solve it.
I want to concatenate items in column A, but it must only concatenated for deferent column H codes. Then it must concatenate in Column b ( worksheet 2 ) next to Column A ( worksheet 2 ) that contains the list of all codes
A001 2 & 16 & 30
B002 2 & 27
WORKSHEET 2 COLUMN B MUST CONTAIN THE FORMULA AND THE ANSWER THAT I WANT