V
Vasanth
Hi
Below is my requirement
I have cells in a excel in the below format
AAA 12323
AAA 56565
AAA 77789
BBB 12
BBB 13
DDD 142
CCC 121
CCC 13
I need to merge the cell of column A until the value is same . My outpu
should be
12323
AAA 56565
77789
12
BBB 13
DDD 142
CCC 121
13
Please let me know if this can be achieved through some macros o
forula
Thanks
Vasant
Below is my requirement
I have cells in a excel in the below format
AAA 12323
AAA 56565
AAA 77789
BBB 12
BBB 13
DDD 142
CCC 121
CCC 13
I need to merge the cell of column A until the value is same . My outpu
should be
12323
AAA 56565
77789
12
BBB 13
DDD 142
CCC 121
13
Please let me know if this can be achieved through some macros o
forula
Thanks
Vasant