Get Column Command Retrieving Blanks

Hello,

I am using the Get Column Command to pull Column A to a list variable. There are only a few items that should be pulled, but it is pulling blank cells as well. Since there is a loop, it is trying to run the script for blanks instead of just continuing to the next step. Wondering how I can get this to not pick up blanks.

Thanks :slight_smile:

Hi @eshea8

After using “Get Column” and saving data to the list. you can add “For each” action and then “If-Else”.
So if element in the list is not empty, then it will be saved to the list:
image

I have also attached an example to my message:)delete_empty_cells.zip (775 Bytes)

A post was merged into an existing topic: Converting CSV to XLSX