In One column I have customer names and I need to replace those with phone numbers from another spread sheet. The other spread sheet has the names and corresponding numbers.
Christopher W.0% (0)
Create an account now and send a proposal now to get this project.Sign up
Clarification Board Ask a Question
Hi Christopher, please can you share a sample of the spreadsheet so I can assess what's required. Data can be anonymised if need be.
AshleyChristopher W.24 Oct 2017
Please see the spreadsheet 'Export' attached. I would like this to end up looking like the 'Product' spreadsheet.
To produce the spreadsheet I have attached 2 data spreadsheets CSW 0800 Numbers and Client Pin Numbers it would need connect to the spreadsheets via the CSW name and Clients name.
The Export spreadsheet would also need to filter out any non 'A City Council' in the Funder Column.