Data Clean-up in Excel
Budget: ₹1,500 – ₹12,500 INR
Hi..this is bit manual task...
1) I have "addresses" and/or "apartment names" in 1 column which are partially incomplete, misspelled or jumbled up.
2) One needs to search for these details (address, apartment name) in Google maps or search bar and paste the right info against each of this cells
there are ~6000 rows aprox
I'm enclosing the file for reference (refer 1st sheet)
1) I have "addresses" and/or "apartment names" in 1 column which are partially incomplete, misspelled or jumbled up.
2) One needs to search for these details (address, apartment name) in Google maps or search bar and paste the right info against each of this cells
there are ~6000 rows aprox
I'm enclosing the file for reference (refer 1st sheet)