Remove certain cells in one row

Hello.
I am trying to remove only some of the cells from a single row.
Because the data has its own headers in the first row.
In the second row, also has headers again with the first data.
The other rows are fine with each datas.
In this case, I want to remove the excess headers from the second row but want to remain the data from that row.
Can someone please teach me how can I remove it?
I got that data from data scraping but the original data table is a little bit wrong and so I need to remove it by myself in the uipath activity.
Please help me.
There is an attachment file below.
datascraping.xlsx (10.0 KB)

Hi.

How about specifying a range such as “A: H”, “I: P” in “ReadRange”, deleting duplicate rows and then merging?

Thanks.
-Tera

1 Like

Hello @tera
Thank you for your reply.
I did like you said and it still doesn’t remove the row.

Help me…

@hsupyaewoon
Is “AddHeaders” checked? If it is checked, please remove it.
If not, I want to check the data table values ​​before and after “Remove Duplicate Rows”.

Thanks.
-Tera

1 Like

I am sorry.
It’s removed correctly.
But the data from first row doesn’t come out.
How do I merge it?

@tera I did it like this.
And this error comes out.
image


@tera
I did the same activity and this time,
the different error comes out.
image

@hsupyaewoon

Created a sample workflow.
I hope this helps you.
Sample.zip (21.7 KB)

Thanks.
-Tera

1 Like

hi @hsupyaewoon, You can use build datatable for specific columns. Create the build data table, then create the columns that you require and then add the data in add data rows, then write in excel.

1 Like

@tera
Thank you so much.
I got it now…:heart:

1 Like

@servesh20
Thank you for your answer.
I will give it a try to your suggestion too.
Thank you…

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