I have a table that contains many rows of data for a unique account number:
uid number phone_number
1 987 9725551212
2 987 9725551212
3 987 4695551212
4 987 2145551212
I need to remove the duplicates and create a single row of the data with the number and each unique phone_number.
number, phone_number1, phone_number2, phone_number3..... phone_number15
I cannot seem to get all the numbers uniquely.