count value in a column based on another column value

[Pol]

Hi, I would like to ask some help regarding this, I want to count the value of column1 base on the value of column2. I want to know how many BM in column1 which is SHS in column2. 

Column1	Column2
BM	SHS
BM	SHS
IT	SHS
IT	SHS
ENGG	SHS
ENGG	SHS
BM	TER
BM	TER
IT	TER
IT	TER
ENGG	TER
BM	TER

Thanks, in advance!

[Mahesh0016 · Accepted solution]

@Pol 
I hope it's helpful for you.

thank you!

[Pol]

@Mahesh0016 

thanks for the help.

but how about if the data is like this and i want to show the result in a card like BM=2(SHS)

Column 1 Column2

BM            SHS

BM            SHS

BM            TER

IT            SHS

IT            SHS

IT            TER

ENGG            SHS

ENGG            SHS

ENGG            TER

Thanks, in advance!