How to remove Empty rows or rows with whiteSpaces in excel file

Hello All,

I’m attaching my sample excel file for reference, In which rows 11,18,20,22 of Column has whitespaces in them.
I need to delete all the empty rows or rows with whitespaces in excel file.

Any leads or help is much appreciated.
Sample.xlsx (15.3 KB)

find starter help here:
RemoveBlanks_1Col.xaml (8.0 KB)
GetRowsWithNoBlanksInAnyCol.xaml (7.9 KB)

1 Like

Hi @ppr , Thank you so much. Solution provided by you working.

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.