Hello! I'm not sure if I understand the question, but I think to concatenate a range of data, You just use = A1&B2 and just drag it all over the range you want to concatenate.

I also learned about concatenate function through https://www.efinancialmodels.com/kno...se-2-formulas/. You can check this out.

Hope this helps!