I have a table that contains phone number and email addresses, this table was created in a way that every time a new phone number or email address is created, for the same client, it creates a new row.
I need a way to get a report that shows all the phone numbers and email addresses per client.
UniqID, UniqClient, PhoneNumber, EmailWeb
3, 66, 4164445555
5, 66, , email@example.com
In this example, the first row contains a phone number and the second row the email address (for the same client - 66).
I need to get one row with phone number and email address.
Any help is truly appreciated.
Thank you very much.