Need help on calculating the percentage?

Hi there,

I need help on calculating percentage of a certain sequence.

E.G:
For coloum ABCD i have a list of E/O
A1 B1 C1 D1
E O E O
Follow by
A2 B2 C2 D2
E O E E

Something like:
EOEE
EOOO
EEEO
EEOO
OEOE
OOOE
OOOO
EEOO
EEOO
EOEO
OEOE
OOEE

how do i calculate the percentage for E occuring again after E on each columm? And E occuring after O? O occuring after E for every columm A,B,C and D?

Thank u very much..