Frequency Distribution of streaks

[franzpeter]

Hello, I need the frequency distribution of streaks like

0
-1
-1 -> 2
0
0
-1
-1
-1 -> 3
0

Is there a way to create a column like column 2 in excel so that I can create a histogram that shows the data.

Thanks for any help.