Hello to all...

I have in a table the following information starting in G36 (Designator) and Box Serials (H36) as shown in the Table below:

Designator Box Serials

1 KVZV, XNHM, QJFW, GFVN,
1 PBMG, BXQD, LLRZ, CGJNL,
2 ZDTN, WPLS, MZGC, HKDT,
1 QFXB, BMVV, VGHF, VXPK,
2 ZFTN, RCJD, DCFV, GXRX,
1 SXDX, CPSM, KXTK, PHCX,
2 QVJT, LWCK, TRWL, LPZQ,
1 PTRX, CPKD, LXJC, KTNV,

While reviewing this, I have in cell G63 the Criteria Value (1) and in cell G64 the criteria value (2).

Can anyone help me to find a formula to concatenate the box serials accordingly with the Criteria/Designator value (1 or 2) in cells H63 and H64 respectively??

I've been doing some searching, but not close to what I am looking for. I know about the Morefunc add-in, but I can not install it in my office computer. I can not also record UDF/VBA codes, due security excel settings and because the original file is on a distribution list, that will imply to attach also the UDF/VBA code in the e-mail. These are my reasons to avoid morefunc add-in and VBA/UDF codes.

Hope somebody can help me with my thread. I have received help in other threads and everyone kindly helped me.

Best regards and please have a great day.

Samuel Cruz.
Matamoros, Mexico.