Delete Group B values from Combined Group A+B column

[DD BIW]

I receive a report that has both Group A values and Group B values in a combined column.
I need to remove Group B values so that I'm left with only Group A values.
Note: Group A may have multiple entries of same value which needs to remain.
Any quick solutions to accomplish this?
Thanks!

 

[dreid1011]

If you have a way to sort them by Group A and Group B, the easiest method would be to sort them, then highlight all of Group B and manually delete the rows. Otherwise, I'm sure a formula option can be suggested to return the results of just Group A if you do not want to permanently delete Group B. Though, you will have to provide some sample data and it's layout in order for us to offer more than this.