Assume your data in Sheet1 A1:C8

In Sheet2:
Header in row1

In B2:
=IF(ISNA(MATCH(1,(Sheet1!$A$2:$A$8=$A2)*(Sheet1!$B $2:$B$8=B$1),0)),"",INDEX(Sheet1!$C$2:$C$8,MATCH(1 ,(Sheet1!$A$2:$A$8=$A2)*(Sheet1!$B$2:$B$8=B$1),0)) )

ctrl+shift+enter, not just enter
copy across and down


"Lynndyhop" wrote:

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,