How to merge 2 lines in a table into one

[mah]

Hi,

I have a table like this : 

test	count
test AA	1
test AB	2
test C	3

I want to merge "test AA" and "test AB" which will give me a count of 3 together.

What I want :

test	count
test A	3
test C	3

How Can I do that ?

[richgalloway]

The best answer will depend on the nature of the test field, but this is one way to do it.

... | eval test = substr(test,1,6)
| stats count by test