Merge cells based on condition

[Amulya_A]

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

[Pamela_Sibaja]

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.

Example:

1. Option 1:
   
   

2. Option 2:
   

   
   
   

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

[postwick (Paul Ostwick)]

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?