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!