I would like to merge 2 adjacent cells (Item 9 and 10) and (Item 7 and 8) in my Item Number Column. The reason is one of the item is a Primary part and the other is an Alternate part for each item. How do I do this? I do not want the other cells to be merged, just the items shown in Column A (Item)
Hello,
I don't have an answer to how you want to do it as in the OP, but what if there was another BOM column "ALTERNATE P/N"?
This column would display all alternate P/N's as a custom property.
The "ALTERNATE P/N" BOM column would be a custom property type, read directly from all parts/assemblies.
Blank for all that don't have an alt p/n and listing the alt p/n of those that do.
No limit on the number of p/n's and no need to maintain separate SW files for the alternates.
Just have to maintain the list of alternates (this would permit a delimited list of >1 p/n), in the files that have such, when a new alt p/n is added or when one is removed or edited
Whether to revision on an alt p/n change is up to you (recommended).
These alt p/n's can also be listed directly on a part's drawing.
And if such parts w/alt p/n's are removed from an assembly or its quantity changes, you don't need to sync all of its alt p/n's.
Kevin