If %tage are same club the data

[shan]

Hi,

I need a macro which will club the data if horizontally %tage are same.

Have attached a file with examples for your reference.




Regards,
Shan

[shan]

Attaching a updated file for better understanding

[shan]

Can anybody please help me on this macro.

If you require any more information please let me know.

Thank you

Regards,
Shan