As you can see in the attached image my BOM is kind of a mess. The numbering scheme is based on the order that I added them to the assembly. I've also deleted all of the fasteners that were in the assembly because I don't want them on the BOM. This leaves the numbering system with a lot of blanks.

What I would like to do is sort the BOM by p/n and then have the item No. match with the new number i.e. Item No 1 = 82491294-1, Item No 2 = 82491294-2 etc...

Is there a way to do this or is the perhaps a different method than what I listed that I should be using?

Thank you,