merge columns

Hi, I was search online and found old thread Merging two columns; only overwriting blank cells with the solution below which works great but only if I type in the =K7 formula in each cell. I will have 1000's of blank cell after I do a Xlookup. Is there anyway to get the formula to auto fill all...

Hi All, I've searched the forums for this but cant seem to find a solution. I have multiple worksheets in a workbook, each worksheet has around 7 or 8 columns and the number of rows vary in each workbook. i'm looking for some vba code that will merge the columns next to each other rather than...

Hello, I'd like to ask for help with some vba coding. I have text (of varying lengths), all in column A but only every 8th row. Currently, the text is not wrapped so it extends across several columns. I need to keep those texts within specific columns only (from A to J) but the row height does...

I have seem many VBA solution to merging cells in rows based on similar values, but I need to achieve this for columns (without any error messages), ie. merging columns within one row and then repeating down all rows. The range where data will merge is C3:AC176 (although if this could change...

In a situation where not every column has a value, the Merge Columns feature adds a delimiter even if a cell is blank. Thus a result can be like: IL,KS,,,,NY ,,,,,FL ,CA,,,, GA,FL,,DC,KS,CA rather than: IL,KS,NY FL CA GA,FL,DC,KS,CA Basically, it'd be nice to recreate the new TEXTJOIN...