Hi, thank you for your response, I had that though and I was able to convert the data to use the same column for the phone number, and another column to display the type of phone number: Example: id number type 1 111 ph1 1 222 ph2 1 111 ph5 2 333 ph3 2 444 ph4 My problem here is removing the duplicate numbers, and since every ID has at least 3 numbers, I have a lot of data. The result was would not fit on an excel spreadsheet. Is there a way to "clean" the data in this format?
... View more