Split lines in the excel have to be merged into a single row

[Iswarya_P1 (Iswarya P)]

In Excel, the information of single-row data is split into two lines. need to combine into a single row.

For your reference, attached the Excel
Book1.xlsx (9.1 KB)
file.

Cheers!
Happy Automation

[Praveen_Mudhiraj]

Hi @Iswarya_P1

you can try by using this xaml, hope it may help to you !
and the output as expected

test.zip (12.1 KB)

[Iswarya_P1 (Iswarya P)]

Thanks.

I am facing another scenario within the split lines. I have shared the Excel below. Kindly assist me.

Cheers!
Book1.xlsx (8.8 KB)

[Praveen_Mudhiraj]

Hi @Iswarya_P1

No worries cool

Try this one for your scenario ,I was attaching the xaml and also the output of the screenshot !

removing the null columns.zip (7.8 KB)

Cheers!