Categorizing the below range for entire column into header wise.

sanjanakuril 

Here is a solution, if I understand your issue.

With the left function, you will get the first number of your argument. Multiply it by one in order to have it as a value.

Second, create a table showing that number 1 = ABC, 2 = DEF etc.

Third, with an xlookup, associate the number to the code.

Fourth, create a pivot table appropriately

Fifth, copy as values if necessary

Hope it helps