How do I merge cells

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

@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


Kindly share the solution, it may help others

1 Like

Hi @Luo ,

Here is the post to do the merge cells.

Thank you