Here is a screen shot of some data:
[![enter image description here](https://i.stack.imgur.com/ecYfX.png)](https://i.stack.imgur.com/ecYfX.png)

I would like to build a new column that is the the string in column A the total number of times it occurs.

So entry "Too expensive" would be on 26 rows then under that would start "Don't want it" taking up 6 rows, then "too expensive" (different since lower case) would take up another 6 + 5 from row 14.

So just a new column that is each string the number of times it appears. Inverse pivot tabling, if you will.

How would I do that? I tried playing with rept() but that put everything in one cell.