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)
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.
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.
