I will need to create a pivot chart according to the serial no. For eg: All102, All101, All103, AIM102,AIM104, AIM103, AIE103,AIE102. I will need to group them in a way that AIM103 and AIM104 falls into the same category, AIM10X and create into pivot chart according to the category. Thanks in advanced.
