How do I merge cells

InputFile like the first pictuer
image
i want to result like the second pictuer,how to do?
image

@Luo ,

You can acheive this using VBA, write a macro in a text file and using exccel application scope open the target excel and run the VBA code activity with that text file macro.

For the macro check this link:

Thank you. It’s been settled

1 Like

@Luo,

Kindly share the solution, it may help others

Hi @Luo ,

Here is the post to do the merge cells.

Thank you
Balamurugan.S