I am working on a report Which would be like following

This is what i have:


company_no dept_no count
1 2 10
1 3 11
1 4 39
2 1 15
3 2 99
3 3 74

I would like to show this data as below:

company_no dept_no count
1 1 0
1 2 10
1 3 11
1 4 39
2 1 15
2 2 0
2 3 0
2 4 0
3 1 0
3 2 99
3 3 74
3 4 0

How can I do this.

Thanks.