I have a table like:
CustNumber ContactType ContactValue
1123 1 310-555-1012
1123 2 myContact@LA.com
1123 3 213-421-5027
5678 1 Info@domain.com
5678 3 213-123-4567
I want to return records like
CustNumber Phone1 Phone2 Email
1123 310-555-1012 213-421-5027 myContact@LA.com
5678 213-123-4567 Info@domain.com
