Hello All,
I am trying to loop through values in a column and input them into a list (on a separate cell in the sheet). However, if while looping, a blank cell is encountered, I do not want that value to be added to the list. Is there a way to do this without VBA and if not, would you be able to help me write a script that allows me to do this? Thank you very much.
I am trying to loop through values in a column and input them into a list (on a separate cell in the sheet). However, if while looping, a blank cell is encountered, I do not want that value to be added to the list. Is there a way to do this without VBA and if not, would you be able to help me write a script that allows me to do this? Thank you very much.