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?
Can check the below similar post. It is using the Invoke VBA activity and the vba script to achieve the same.
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
Thanks and Regards