I want table outcome like 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]

Anyone know how to do this?

Thanks

[D19PAL]

Any help on this please?