I need an excel sheet of data formatted/tidied up
- or -
Post a project like this332
£40(approx. $50)
- Posted:
- Proposals: 40
- Remote
- #3936677
- Awarded
437835293571378950491904802691158979221118923659592392849244649935442893549689376830
Description
Experience Level: Entry
I require assistance with a HMO landlord list of data I have on an Excel document.
This document has been exported from a PDF version so therefore there are odd spaces between words and some formatting issues which need to be corrected.
I would like to be able to sort the data more easily and so tidying up of the data would be helpful which I will elaborate on further. The most important information for me is the HMO Landlord Name and corresponding addresses (columns R to U).
I have attached two documents: the first is an example of the exported HMO list (labelled 'HMO list example') and the other, is an edited version (labelled 'HMO list example (edited)') to show how I would roughly like the data to be cleaned up. Please compare both to see the differences.
To summarise, the key changes/edits I would like to see are:
1. removal of spaces between words
2. changing the HMO Landlord name to Title and Surname, so removing the first name as it not needed; for example, if it says Ann Jones in the HMO Landlord name column but the Title is shown in the Licensee name column, this could be changed to reflect the Title as although it's not in the HMO Landlord name column, clearly the name is the same as the Licensee name, it's just detailed differently excluding the Title. For example, it could be Ann Jones in the HMO landlord name column but Mrs Jones in the Licensee column, so it's safe to assume it's the same person. If there is no Title anywhere in the row or if the Licensee is someone different, please change to A Jones in this example so as to not assume a Title.
3. If the HMO Landlord name says Ann and Colin Smith or Ann Smith and Colin Smith for example, I would like this changed to Mr & Mrs Smith. Please use the & symbol consistently for 'and'.
4. I would like for the different types of Licensee's to be separated onto different sheets under each of the following categories:
- Private Landlords (they would be Licensee's which are detailed as an individual(s) name)
- Limited companies (they would be Licensee's which are noted as either Ltd or Limited)
- Partnership (they would be Licensee's which are noted as Partnership)
- Trust (they would be Licensee's which are noted as Trust)
NB you will be able to tell this by the information stated in the Licensee name column - see the HMO list example (edited) sheet for reference. I have done a key to highlight some of the different types. There may be different categories so please create a new sheet/type where applicable.
5. For any address which doesn't have a postcode, please look them up and add the postcode to the data (I don't think there are many). For reference, all addresses are in Bournemouth.
6. Please add filter functions to the columns so that I could filter easily by number of bedrooms, reorganise the sheet alphabetically by Landlord Name etc. Anything like this would be really useful.
Any questions, please ask but this is the task in summary.
This document has been exported from a PDF version so therefore there are odd spaces between words and some formatting issues which need to be corrected.
I would like to be able to sort the data more easily and so tidying up of the data would be helpful which I will elaborate on further. The most important information for me is the HMO Landlord Name and corresponding addresses (columns R to U).
I have attached two documents: the first is an example of the exported HMO list (labelled 'HMO list example') and the other, is an edited version (labelled 'HMO list example (edited)') to show how I would roughly like the data to be cleaned up. Please compare both to see the differences.
To summarise, the key changes/edits I would like to see are:
1. removal of spaces between words
2. changing the HMO Landlord name to Title and Surname, so removing the first name as it not needed; for example, if it says Ann Jones in the HMO Landlord name column but the Title is shown in the Licensee name column, this could be changed to reflect the Title as although it's not in the HMO Landlord name column, clearly the name is the same as the Licensee name, it's just detailed differently excluding the Title. For example, it could be Ann Jones in the HMO landlord name column but Mrs Jones in the Licensee column, so it's safe to assume it's the same person. If there is no Title anywhere in the row or if the Licensee is someone different, please change to A Jones in this example so as to not assume a Title.
3. If the HMO Landlord name says Ann and Colin Smith or Ann Smith and Colin Smith for example, I would like this changed to Mr & Mrs Smith. Please use the & symbol consistently for 'and'.
4. I would like for the different types of Licensee's to be separated onto different sheets under each of the following categories:
- Private Landlords (they would be Licensee's which are detailed as an individual(s) name)
- Limited companies (they would be Licensee's which are noted as either Ltd or Limited)
- Partnership (they would be Licensee's which are noted as Partnership)
- Trust (they would be Licensee's which are noted as Trust)
NB you will be able to tell this by the information stated in the Licensee name column - see the HMO list example (edited) sheet for reference. I have done a key to highlight some of the different types. There may be different categories so please create a new sheet/type where applicable.
5. For any address which doesn't have a postcode, please look them up and add the postcode to the data (I don't think there are many). For reference, all addresses are in Bournemouth.
6. Please add filter functions to the columns so that I could filter easily by number of bedrooms, reorganise the sheet alphabetically by Landlord Name etc. Anything like this would be really useful.
Any questions, please ask but this is the task in summary.
Emma F.
100% (1)Projects Completed
1
Freelancers worked with
1
Projects awarded
33%
Last project
10 May 2023
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Hi Dear,
Did you have PDF format about it..... -
What About the font size, style, line & letter spacing?
-
Hello Emma, I would like to know the data size. How many rows?
it would be great if you can attach the file so I can have better knowledge of the task required.
Have a great day.
105970710596851059680
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies