Luo
(Luo)
March 31, 2021, 5:45am
1
InputFile like the first pictuer
i want to result like the second pictuer,how to do?
sarathi125
(Parthasarathi)
March 31, 2021, 6:03am
2
@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:
Hi,
I have data in columns A to U like. Column A data as below ( data starts from row 2)
Colum A
A
A
A
B
B
C
D
E
E
E
now need to merge few columns C, E, O & P based on values in A, in all these columns,
rows 2 to 4 should be merged ( All...
Luo
(Luo)
April 1, 2021, 6:37am
3
Thank you. It’s been settled
1 Like
sarathi125
(Parthasarathi)
April 1, 2021, 11:21am
4
@Luo ,
Kindly share the solution, it may help others
1 Like
balupad14
(Balamurugan (BalaReva))
April 1, 2021, 11:30am
5
Hi @Luo ,
Here is the post to do the merge cells.
Hi @anjalimishra ,
Please take a look this activity. It has facility to merge and un-merge the cells.
Regards
Balamuruga.S
Thank you
Balamurugan.S