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 |
| T700HKNGA |
| T700NGDA |
| T700YBWA |
| T701RBMA |
| T7051BEA |
| T721RMRA |
| T734BRA |
| T734GRA |
| T741RGRA |
| T745WBEA |
| T749A |
| T750AUGA |
| T750BEGRA |
| T750MABEA |
| T777GRA |
| T777GRBEA |
| T779GRBEA |
| T782GPLA |
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)
4 Replies
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) & "")
- Hi
Select the range of data you want to rearrange and select Copy Ctrl+C
Select the first cell where you want to paste the data, and on the Home tab, click the arrow next to Paste, and then click Transpose.
