How to add subtotal rows to particular parts of a data set

[Dnatour]

Hi all! 

I have a data set that looks like this and I want to add a subtotal row under each unique security. How can I do this? 

ID	shares	Market value	proceeds
a	23	43	33
b	33	44	65
b	45	55	89
b	987	76	54
c	45	65	34
c	56	54	34

[binuacs]

@Dnatour one way of doing this with the batch macro

[Raj]

@Dnatour 
one way of doing this without macro.
hope this helps.