I need the table outcome liks this

[D19PAL]

Hi,

This is what I want in a table.

Requirements 

Count if student and teacher have the same company. So student 1122 has 4 companies and his teacher is 167, they share the same company asda. So I want to see both rows, see below 

Form,Student,company,dept, created in script 

4,1122,asda,a,1

5,167,asda,a,1

6,167,comment,a,1

13,114,comment,a,1

8,167,foxy,a,1

12,113,foxy,a,1

Data.....

Form,student, teacher,company, dept

1,1122,167,tesco,a

2,1122,167,sainsbury,a

3,1122,167,Morrison,a

4,1122,167,asda,a

5,167,113,asda,a

6,167,113,comment,a

7,167,113,taser,a

8,167,113,foxy,a

9,113,167,asda,a

10,113,167,roxy,a

11,113,167,troxy,a

12,113,167,foxy,a

13,114,167,comment,b

14,114,167,black,b

15,114,167,blue,b

16,114,167,red,b

[D19PAL]

Any help on this?