How I can clean the blank rows in Excel File

Help Studio
1

Hi Every one

I have Excel file and there are some empty rows how i can clean or clear that i try to do that but it is not work with me

can any one help me please

Thank you

2

A simple way would be to sort the worksheet so the blank rows are sorted to the bottom.

4

you mean sort data table?

5

use filter data table activity

1 Like
7

can tell how i can do that because i try and it is not so for all sheet

8

Thank you

But how i can do that for all columns ?

9

Do you want to remove entire row if any column value is empty?

10

yes i mean for example i have

           A                B           C

1 row1 row2 row3

2

3 row1 row2 row3

4

5 row1 row2 row3

so the row 2 and 4 there are no value i want to remove that

11

But im asking do you want to check empty values for column A or all the columns

13

All Column

14

this is the Q

Ensure to clean the blank rows in sheet_A & sheet_B

15

Oky. Then use this to filter for each sheet

Untitled
Untitled1623×1146 57.4 KB

1 Like
17

Hey @coder

Please use Filter Data Table activity to filter the columns which are having empty rows.
you can add multiple filter conditions to check particular value is empty or not.

please find attached image for more information.

Filter Datatable

Hope this solve your problem.

Regards,
Vijay.

1 Like
18

Thank you All it is work

19

Thank you

20

Welcome @coder :slight_smile:

21

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