I have two tables:

| Cert | Type |
| --- | --- |
| 101 | Roof |
| 102 | Sewer |

| Cert | Contact |
| --- | --- |
| 101 | Bob |
| 101 | Tom |
| 101 | Mary |
| 102 | Tom |

They want a report like:

| Cert | Type | Contact1 | Contact2 | Contact3 |
| --- | --- | --- | --- | --- |
| 101 | Roof | Bob | Tom | Mary |

My tools are SQL and BIRT. I am really just looking for some direction. I assume I need to reshape the data but am not sure where to start.