Excel Read Column picks up junk data with whitespace

Help
1

Hi, I am using Excel Read Column, only that it captures additional unwanted data E.g.

Column1
Column2
Column3
" "

Edit: So I figured out what was causing this, and it is a cell that contains whitespace on the very next row

How do I modify Read Column activity to not read the cell with whitespace?

Reason why I am using Read Column instead of Read Range is because I want to retrieve 1-dimensional data to transpose columns to rows (instead of reading each column as 2-dimensional data)