In Progress

Excel Table Conversion

I have a large excel spread sheet that I need converted into a sheet with a single row. I then need that data converted into a five column spreadsheet based on the data contained in the cells.

The datasheet is approximately 9200 rows and goes from Column A to Column FT. Each cell containts data in this format: "3152;Few vacancies - Willcox, AZ:"

Once the data is located in a single column(might have to take multiple pages as I am not sure about column limits in excel) I then need it converted into five columns of data. Each cell is already prepared for conversion. The five columns will be the ID number, delimited by the Semi-colon. The next will be the vacancies, delimited by the "-", followed by the City and State. The last two columns will be a copy of the previous, as I need an additional column for both the city and the state individually (so all three combinations).

There are some cells that have compound information in each section. For example there might be two cities listed in a cell: "3576;Few vacancies - West Oahu, HI, Central Oahu, HI:". In this case, two rows are required, one for each city, with the same ID number.

In the event that the cities are listed in all caps, convert them to proper capitalization (as per the excel formula).

The data in the columns needs to be cleaned up after conversion. By this I mean that there can be no additional spaces either before or after a piece of data.

Some of the cells might not contain data, and might look like "253;:". This data can be ignored. If there are duplicates (highly likely), then they should be removed as well.

I have attached a sample page with two columns. PLEASE REVIEW THE SAMPLE BEFORE MAKING A BID. ALSO, PLEASE ASK CLARIFICATION QUESTIONS BEFORE MAKING OR ACCEPTING A BID. THERE IS A CLARIFICATION FORUM FOR SUCH PURPOSES, SO PLEASE DO NOT BID ON THE PROJECT AND THEN SEND ME ENDLESS REQUESTS FOR CLARIFICATION. IF YOU DO NOT UNDERSTAND WHAT I AM ASKING, ASK NOW. IF YOU ACCEPT THIS JOB AND LATER DETERMINE YOU ARE UNABLE TO COMPLETE IT, I WILL LEAVE FEEDBACK INDICATING AS MUCH.

I am looking to get started ASAP. I don't have a specific time frame in mind as to when I need the results, but sooner is always better.

Skills: Data Entry, Data Processing, Excel

See more: excel conversion table, sample excel conversion table, what do you mean by data entry, vacancies in data entry, time in az, questions to ask before accepting a job, me excel, ask excel, data conversion table excel, table conversion ask bid, conversion excel table column, conversion table excel, excel spreadsheet formula, excel sheet formula, vacancies job, vacancies it job, looking for job vacancies, job vacancies data processing, data entry job vacancies, west, time table, job vacancies data entry, format excel, excel table, excel spread sheet

About the Employer:
( 6 reviews ) Austin, United States

Project ID: #602976

Awarded to:

best4best

I have viewed the "Sample" and "Sample Finish". Project requirements are clear to me. I can start right away and complete it in few hours. I am an Excel expert and accurate data entry professional. Please take a look a More

$35 USD in 0 days
(102 Reviews)
5.6

16 freelancers are bidding on average $51 for this job

lucky2gaf

Hi, please view my PM for more details, thanks.

$50 USD in 1 day
(106 Reviews)
6.0
Bajrangpali

Hello, Lets Start.

$50 USD in 2 days
(64 Reviews)
5.5
iDivya

Please read my message.

$55 USD in 1 day
(23 Reviews)
5.0
asaikiran1979

Mike, see PM.

$50 USD in 1 day
(47 Reviews)
4.9
theMagicNumber

Dear sir/madam please refer to your PMB. Thank You.

$50 USD in 0 days
(5 Reviews)
4.5
mohanlg

Hi, Ready to start work immediately. Thanks sunny

$30 USD in 0 days
(26 Reviews)
4.3
FlashBack

please view the PMB

$50 USD in 3 days
(13 Reviews)
3.9
adeeltalib

i will do my best

$30 USD in 10 days
(6 Reviews)
3.8
BestForever

hello friend, I understood your project requirement, it's easy for me I can do it. thanks

$50 USD in 3 days
(4 Reviews)
2.7
mamun7374

Hello sir, Please check Inbox.

$100 USD in 7 days
(1 Review)
2.4
lalinart

HI, I am intrested your project please reply me.

$50 USD in 2 days
(0 Reviews)
0.0
vishla

Excel Table Conversion

$35 USD in 10 days
(0 Reviews)
0.0
rmssr

I can't open your attached file.

$100 USD in 4 days
(0 Reviews)
0.0
simmisummi

like to do.............

$35 USD in 5 days
(0 Reviews)
0.0
mdraut

I CAN DO IT . REPLY IF YOU WANT. REGARDS

$51 USD in 1 day
(0 Reviews)
0.0