How to combine 2 rows(with header) into a single row header?

Help Activities
, ,
1

Hi,
I have an excel which contains headers in first 2 rows. I need to combine these 2 rows into a single header row. Can anyone help me?

Screenshot 2023-09-11 145541
Screenshot 2023-09-11 1455411267×133 3.43 KB

2

Hello @angush.st

Can check the below similar post. It is using the Invoke VBA activity and the vba script to achieve the same.

Thanks

1 Like
3

Hi @angush.st

One logic would be to retrieve the second header row and combine with first header and add in excel sheet.

Then remove the row where the second header lies.

Hope this kind of logic helps :pray:

Thanks and Regards
Nived N

1 Like