Dear all,
I am dealing with a large file, which looks like in a pic below.
As you can see the cells marked in yellow are undesired. I want to remove these blank cells to shift the cells up to align it with data.
Is there any formula to do it? Please help
Thanks
excelhelp.png
Bookmarks