How to Group Cells/Data together? skip UP blank cells

Hello Folks

I am brand new here so hoping for the best!!!

Trying to get this done without VBA as it needs to be done on the fly i.e. no user intervention. In my worksheet I have managed to extract unique records from the data set below and sum up the corresponding value of like records,

Col A Col B
abc 123
abc 123
bcd 234
bcd 345
def 456
efg 333
fgh 567
efg 333

into the following

Col C Col D
abc 246

bcd 579

def 456
efg 666
fgh 567

Formula in Column C, =IF(COUNTIF($A$1:A1,A1)=1,A1,"")
Formula in Column D, =IF((SUMIF(A$1:A$8,C1,$B$1:$B$8)=0),"",SUMIF(A$1:A$8,C1,$B$1:$B$8)).

What i would now like is to get rid of the intervening blank cells so that the output looks as following..(no manual input like delete cells or menu-->data-->autofilter etc pls)
.
abc 246
bcd 579
def 456
efg 666
fgh 567

i.e. the output is grouped together! for the final presentation to the user. Plan to use Camera took on the output(ed) result!

Any suggestions? Thanks in advance!

Hi,

You can use Data --> subtotal option to add and group data.

Hi

Thanks for your reply, however what i am trying to achieve is "not" to use any User input for getting it done.

I have been looking at Index, Match, Offset, DGet etc but cant come up with a solution.

Also it has to be a NON-VBA solution unless the code can do it with a Worksheet Change event, i.e. no user intervention required. Since the actual & final worksheet with the real data has to be distributed to users besides myself.

And it would be nice NOT to be required to press macro command button etc, i.e. get the unique records & their sums bundled nicely together.