VBA code: Transpose data from column into one single cellģ. Click Insert > Module, and paste the following code in the Module Window. Hold down the ALT + F11 keys, and it opens the Microsoft Visual Basic for Applications window.Ģ.

=B3&','&C3&','&D3&','&E3 Press Enter key, then the cells are combined with comma separated.ġ. For instance, you want to combine the cells of each row across column B, column C, column D and column E into one cell with commas, please use below formula in a blank cell. Under Table Tools, on the Layout tab, in the Merge group, click Merge Cells.

For example, you can merge several cells horizontally to create a table heading that spans several columns. You can combine two or more table cells located in the same row or column into a single cell. Select the cells that you want to merge.Įxcept the Concatenate function to merge a list of cell values, you can apply the following VBA code to get the result as quickly as you can. Using a Formula CONCATENATE + TRANSPOSE to Combine Values. Transpose data from column into one single cell with Kutools for Excel Transpose data from column into one single cell with User Defined Function This article, I will talk about some quick tricks for you to solve this task in Excel. When you need to transpose a list of data into one single cell in a worksheet, normally, you can apply the Concatenate function to merge the list of cells into one cell, but, it will be complex if there are huge data need to be combined. How to transpose data from column into one single cell in Excel? Excel Merge Columns Into One Cell Formula.

Kutools excel formula help