Hi Mohony,

I suggest the following appraoch:

Using columns F:J for the split info.
F1 = "ABL"
G1 = "AGL"
and so on

For F1 use the formula
'If($C2=F$1,F$1,"")

And copy this formula to the columns F:J for als the used rows.

HTH.

Wouter.