Convert 1 row of data to columns
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.
|