Hi there,

Can't quite wrap my head around this one. I have the following data:

Ee# Contact Type Contact
1 Home P 111-2222
1 Email
2 Home P 222-3333
3 Home P 333-4444
3 Mobile 444-5555
3 Email
4 Mobile 555-6666

And need to make this

Ee# Home P Mobile Email
1 111-2222 -
2 222-3333
3 333-4444 444-5555
4 555-6666


Any suggestions?

Many thanks,