I'm kind of struggeling with VBA for excel. I want to consolidate data in one specific column B by removing blank cells. Unfortunately, I can't delete the entire rows as it will remove data in other columns.
Any idea how to loop through column B and move up non-blank cells?
Dataset and expected result
Any idea how to loop through column B and move up non-blank cells?
Dataset and expected result