how to solve this issue for count

hi

i need how to count value for this my table like this users entry data will entry users some time different data

Id Items
1 AA
2 BB
3 CC
4 DD
5 EE
6 FF
7 Male
8 Female
9 Male
10 Female
11 VB.net
12 Asp.net

but i need output like this

I need Count Details like this

AA BB CC DD EE FF Male Female Vb.net Asp.net
1 1 1 1 1 2 2 2 1 1

Mark as Answer if its helpful to you

Kumaraspcode2009@gmail.com