I have a large list that I need sorted. Basically it will need macros and some conditional formatting. I have provided a sample of the spreadsheet I'm working with.
If the person has a phone number all their info must be duplicated into a new row and the phone number copied into that new row. Each row can only have one phone number to match with the person. Same with emails - Emails will need a duplicate row for each email provided. The end result will look like 6-10 rows where the columns are identical until you reach the phone number and email field. The first few rows are how the end result should look.
This is a one time thing - but we are starting to need work like this more and more and we would like to find a dedicated excel MASTER to handle these issues for us with the fastest TAT possible. We do not want people that will manually move things and grind it out. We need solid pros that can sort things using the most advanced techniques available on excel.
52 freelancers are bidding on average $23 for this job
Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards. Stay tuned, I'm still working on this proposal.