Is there a way other than manually to group either in the raw data or in pivot table by like numbers and like names? Say the first three digits of a number and the first four digits of a name. Need to combine by grouping and get summaries of sales amount by those groupings.. Thanks.