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.