Q1. How identify data of two coulams


Q2. Every cell count and show result like
I need like
Coulam A Coulam B
500 1
500 2
500 3
800 1
800 2
800 3
800 4

800 5
800 6
600 1
600 2
600 3
600 4
700 1
700 2
I want to count like coulam B i have data in coulam A and like this

I have two coulam with name as lower,upper,propercase i want to do all in
same case like in proper case how?