I need to remove empty row from datatable with consider all column

[Jijendiran_Murugan (Jije)]

above input example image attached

I need to remove empty row from datatable with consider all column (column name is dynamic) and each it will come different column name and column will assign in variable like column name=“col1,col2,col3,col4,” each time it will change

below image output

[Yoichi]

Hi,

Is the above input sample?
If so, can you also share expected output?

Regards,

[pravallikapaluri]

Hi @Jijendiran_Murugan

Can you specify the expected output from the Excel

[Jijendiran_Murugan (Jije)]

pls check i have updated

[Jijendiran_Murugan (Jije)]

please check i have updated

[Parvathy (PS Parvathy)]

Hi @Jijendiran_Murugan

Check out this xaml file.

Sequence4.xaml (9.5 KB)
Input

Output

Hope it helps!!

[vrdabberu (Varunraj Dabberu)]

Hi @Jijendiran_Murugan

Please follow below steps

Invoke VBA Code:
RemoveRows.txt (499 Bytes)

WorkFlow:
Main.xaml (13.0 KB)

Input :

Output:

It works
Regards