Not Working, the code i provided to you macro was working perfectly but I just want to remove the Nested ifs because it makes my code to work slow,

While running your code output is coming for the data

1 a c k
1 b d B
1 a e B
1 a f B
1 d g T
2 a c k
2 b d B
2 a e B
2 a f B
2 d g T
2 a c k
2 b d B
2 a e B

Output :-
1, 2 a, b, d c, d, e, f, g k, B, T


But i want is :-
1 b,a,d d,e,f,g B,T k,b,t
2 a,b,d c,d,e,f,g k,B,T

Regards,
Mandeep