Remove empty columns caused by unmerged cells

Occasional Visitor

I have a sheet with a lot of merged cells. After I unmerged that cells , I am left with numerous empty columns in between the remaining data. Is this a quick way to remove the empty columns. Please keep ? 





1 Reply
You could use Go to Special.

1. Select the affected area
2. F5 to open Go to menu, select special
3. Select 'Blanks'.
4. Right click the selection - delete - entire column