Need Help in preparing a productivity report.

[sunilkovid]

Abc School	Processing date	7/7/2018	to	7/7/2018	ABC school	Clearing type	1	productivity report
login level	cust name	domain name	slp	chq	micr	chq date	slip	l1	l2	l3	chi
login id	123456
l3 verfication	Abc School new	Abc School								100
login id	456789
l3 verfication	Abc School new	Abc School								120
l2 verfication	Abc School new	Abc School							80
login id	151880
l2 verfication	Abc School new	Abc School							110

<tbody>
</tbody>

i had data like this and if i pasted the data in my excel sheet 1 i would like to get login id and their verification level and count againt their verification level in sheet 2.


Thanks in advance..