Thank you, I'm going to try these! And the WOT variable can be more than one character. ... View more

Yes, thank you for clearly stating that for me. ... View more

I would need the result to be more like this From: WOT Nb Mbr Type A 5 100 PYGT B 2 20 PYGM C 1 3 CLAS D 20 400 FGP E 1 80 TPEO F 3 10 TPEM G 1 3 WCQ H 20 400 VXZ I 6 140 DIX ... Z 30 600 YNR TO: WOT Nb Mbr Type A-B 7 120 PYG C 1 3 CLAS D 20 400 FGP E-F 4 90 TPE G 1 3 WCQ H 20 400 VXZ I 6 140 DIX ... Z 30 600 YNR   ... View more

The only rules are when there is an A and B they go together, or the other group will be G, P and W, all the other letters stay on their own. I'm so sorry, I'm not so good at explaining what I need. I am so new to this. And yes I guess rolling up means to sum the numerical values. Maybe I should delete my post? 😞 ... View more

shoot, that's a typo. It should be 120 not 127! ... View more

Hi, yes that is just a sample. There are only a few rows, out of about 30, that I need to roll/sum up the others stay as is. The Type is just a going to be description of what they are, the length really doesn't mean anything. ... View more