Thanks for the replies. After grouping by this trait, there's a third column that I need to check and combine some rows with respect to the info under that third column.
But this PartNum column has higher priority so i want to do it first