Forum Discussion
Move Value between blanks and skip the blank cells
Hello, I've column that's include a values and blanks so i just need to move only values without taking the blanks with the formula what i tried is : used =IF(Main!O5,Main!J5,"") so the fo...
Just curious if you need to take the filled cells then why not try pivot and then unselect blank?
I want to do it automatically because i'm dealing with large data so i can't select and delete blanks every time i entered the data