Removing Excel Empty Rows

datatable
excel
studio

#1

Hi all,I wanted to remove empty rows from excel…please share your thoughts…Thanks in Advance…


#2

Hi Gireesh,

Try to select all the data rows in excel sheet and sort them either ascending or descending order. If there is a header, exclude it while doing sorting. So that all the empty rows will go to the bottom.

Thanks,


#3

@Gireesh

read range to Data table and Data table select with Not NULL criteria will result the rows with out Null in column you are looking for. Please let me know if its helpful.

Thanks~Rajesh


#4

Hi could you help us to know how to do this.