Kutools for Excel 24.00 HOT 300+ Powerful Features You Must Have in Excel. Kutools for Excel is a powerful add-in that frees you from performing time-consuming operations in Excel, such as combine sheets quickly, merge cells without losing data, paste to only visible cells, count cells by color and so on. 300+ powerful features / functions for Excel 2019, 2016, 2013, 2010, 2007 or Office 365!

Simplest way would be to add a new column and combine the two you want to merge with a =CONCATENATE(A1, “, “, B1) The A1/B1 are the first cells in each column, the,”, “, is adding a comma and space between the values, but you can use any separator. Watch this short video that shows you how to merge several cells in Microsoft Excel and still retain all the data in both cells. Kindly share if you find thi.

Hi. I have a small task that is similar to some of the other posting on merging, but not exactly the same. I'm trying to merge multiple cells in a single column (varying number of cells) into the first cell of that group without losing the data from the other cells. Here's an example:

Before:

___ __A__ __B__ __C__

1__ __x1_ __y1_ _____

2__ _____ __y2_ _____

3__ _____ __y3_ _____

4__ __x2_ __y4_ _____

5__ __x3_ __y5_ _____

6__ _____ __y6_ _____

After:

___ __A__ __B__ __C__

1.. ..x1. ..y1. .....

... ..... ..y2. .....

___ _____ __y3_ _____

2__ __x2_ __y4_ _____

3.. ..x3. ..y5. .....

___ _____ __y6_ _____

*Ignore the '.' - I can't get the editor to recognize multiple spaces

Is this possible? I want to create the line-breaks between the merged values, and I'd like it to know which values to merge based on which cells in Column A are populated. I REALLY need to learn some VBA...

Thanks,

Bif

Before:

___ __A__ __B__ __C__

1__ __x1_ __y1_ _____

2__ _____ __y2_ _____

3__ _____ __y3_ _____

4__ __x2_ __y4_ _____

5__ __x3_ __y5_ _____

6__ _____ __y6_ _____

After:

___ __A__ __B__ __C__

1.. ..x1. ..y1. .....

... ..... ..y2. .....

___ _____ __y3_ _____

2__ __x2_ __y4_ _____

3.. ..x3. ..y5. .....

___ _____ __y6_ _____

*Ignore the '.' - I can't get the editor to recognize multiple spaces

Is this possible? I want to create the line-breaks between the merged values, and I'd like it to know which values to merge based on which cells in Column A are populated. I REALLY need to learn some VBA...

Thanks,

Bif

Coments are closed