my data in the table is like this
| mailnumber |
type |
email |
| 1 |
inbox |
some inbox message.. |
| 1 |
sent |
some sent message.. |
| 2 |
inbox |
inbox message |
| 2 |
sent |
sent message |
What do i want to achieve is that I want to pivot this data into
| mailnumber |
inboxMessage |
SentMessage |
| 1 |
some inbox message.. |
some sent message.. |
| 2 |
inbox message |
sent message |
and insert the data into new table