I need a database spreadsheet sorted that contains two sets of data . Both sets of data contain a customer number.
Data A is 2 columns, Customer number , Customer name.
Data B is 3 columns , Customer number , contact name and mobile number.
Data B has multiple mobile numbers for the same customer number but Data B does not include every customer number so these two sets of data cant be simply matched by sorting.
There must be a formula for this but I cannot find it .
I am an Australian business analyst with 15 years professional experience sifting through large volumes of data using Excel, VBA, and SQL. My eye for spotting patterns, and creative problem solving approach has meant I have come up with some pretty interesting approaches to solving problems like these, and have been able to clean / process / sort data which others have deemed unusable. I would love to take a look at your sheet!
$21 NZD in 1 day
5.0 (28 reviews)
5.1
5.1
11 freelancers are bidding on average $22 NZD for this job
Hello
I will scrap this url and I will make an excel spread sheet of 2 column. I am expert in excel sheets working. You will got your desired result.
MONEY BACK GUARANTEE
Regards
Asad