Unmerge 2 columns in a row (A:B) for example : column A&B are merged with a cell value Machinery
After Unmerge automatically Machinery goes to Column A and B column is blank but, I need a name automatically for B column (adding column A (Machinery) + word (Desc)=Machinery Desc)
So, I am looking for a macro which will search for merged cells in each row and it will unmerge and put a name for unmerged cells as previous cell name +“Desc” to it.
Not sure if this is possible in a Macro?