BP          I/E

AN02           I
BN02           ECN
EN89           ECN
AN02           I
BN02           ECC
EN89           ECN
AN02           ECC
BN02           ECC
EN89           ECN
AN02           ECC
BN02           ECN
EN89           ECN
AN02           I
BN02           I
EN89           ECN

BP    I    ECN   ECC

AN02  2    3      1
BN02  1    6      9
EN89  4    2      3

TRANSFORM Count(tbl.[I/E]) AS [CountOfI/E]
SELECT tbl.BP
FROM tbl
GROUP BY tbl.BP
PIVOT tbl.[I/E];

BP      ECC ECN I
AN02    2       3
BN02    2   2   1
EN89        5