@Qiu thank you! This worked for me.
My null columns are non-consecutive so I can't exclude them using the input tool by defining a range.
I haven't needed this functionality before and had "tool blindness" so didn't remember it was an option in the data cleanse tool even though I use this tool very often. Thanks again!