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

binu_acs

@Dnatour one way of doing this with the batch macro

SubTotal_20062024.yxmd