I have a table like this
ID TEXT 1 HI 2 HI 3 BYE 4 BYE 5 HI
I need to get a table that look like this
TEXT COUNT HI 3 BYE 2
How can I do so?