Merge cells based on condition

Hi All,

I want to merge the cells based on column 1 .if column value is same then i have to take count of similar values and put the count in column 3.please find the example below

It would be great if someone could help
Thanks in advance

Hi @Amulya_A ,

In my case, you can used an script to execute in Excel or create a Macro in the excel that you used like a template where you put all information prepared before.


  1. Option 1:

  2. Option 2:


Have a great day!
Please let me know if you need anything else.

Why is this what you’re trying to do? This isn’t a good data structure, why do you want it to be like this? What are you trying to achieve?