Hello all,
I apologize in advance for asking a question that has likely been answered before--I am in a new job that requires a good bit of Excel work, and I am not familiar with advanced functions/terms at all so I'm hoping someone can point me in a simple direction. I commonly create spreadsheets that pull from a massive database to list people's contact information. If someone has multiple phone numbers saved in our database, he or she will show up on multiple rows, with one row per unique phone number. I want to find a way to condense the multi-line people into one row each by spreading out their phone numbers into additional "phone" columns when needed. Everything I find on Google relates to removing duplicates instead, but each row has different phone numbers so I don't want to lose any. I also have other info like addresses on these lines, and many hundreds of names, that are complicating my efforts. I am attaching a sample screenshot that shows what I'm hoping to do in a simplified format. Any suggestions, keeping in mind I am not very knowledgeable?Excel.jpg
Bookmarks