ExcelBanter - concatenate with arrays

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - concatenate with arrays (https://www.excelbanter.com/excel-worksheet-functions/238666-re-concatenate-arrays.html)

Bernd P

concatenate with arrays

Hello,

Array-enter into a sufficiently long area with 1 column:
=reshape(TRANSPOSE(A1:A3)&B1:B3)

My UDF reshape you can find he
http://sulprobil.com/html/reshape.html

Regards,
Bernd

All times are GMT +1. The time now is 05:32 PM.