Forum Discussion
Solved
multiple column values into a single row
Hello, Good Day! I have a 1000 product list in a column, want these in a comma separated format. Concatanate Function or anything else can i use and how? T700BRWA T700GRWA T700HKNG...
najim_uddin Insert a comma in cell B1 and copy it down and then the cell where you want the result, insert the formula =CONCAT(A1:B20)
najim_uddin Insert a comma in cell B1 and copy it down and then the cell where you want the result, insert the formula =CONCAT(A1:B20)
Thanks Doug Robbins,
I have tried below formula but your formula is best i think
=CONCATENATE(TRANSPOSE(A2:A15) & "")
I have tried below formula but your formula is best i think
=CONCATENATE(TRANSPOSE(A2:A15) & "")