Completed

organize data in excel spreadsheet

The problem:

we converted a .pdf list to an excel file, but the data didn't come out quite right.

the list is 6386 rows and 4 columns wide.

it should be 8 columns wide, but half of the data for each record is on the second row of the spreadsheet. so there are really about 3,000 records but their data is on two rows.

it is not consistent as to whether the data in the first row goes with the data in the second row, so you must manually review to see which data goes with with record.

The assignment:

move the cells into proper alignment so that each company's complete record is all contained on one row.

the 8 column headers should be:

Business ID

Business Name

Email

Address

Owner

Phone

Application Date

License Issued

Also remove "Owner:" and "Phone:" etc. from each of the cells so that the spreadsheet can be sorted by each field.

I have attached a screenshot sample of the spreadsheet to show you how the data is arranged.

Evner: Dataindførsel, Datasøgning, Databehandling, Excel, Websøgning

Se mere: how to organize data in excel for analysis, how are data organized in a spreadsheet, formatting data in excel 2010, how to organize an excel spreadsheet, ways to organize data in excel, how to sort data in excel, how to organize raw data in excel, data organization in spreadsheets, paste data excel spreadsheet, exporting data excel spreadsheet quality center, google finance data excel spreadsheet, data excel spreadsheet set organization, copy data excel spreadsheet, copy web data excel spreadsheet, changing word data excel spreadsheet, create front end enter data excel spreadsheet, html format cut data excel spreadsheet web page, reading data excel spreadsheet web form, access vba data excel spreadsheet, scripts import text file data excel spreadsheet

Om arbejdsgiveren:
( 20 bedømmelser ) West Jordan, United States

Projekt ID: #17588266

Tildelt til:

hmryz

Hi! I'm interested on working on your project. I have experience working on excel/data entry and I'm available to start immediatly. I've checked the image attached and I'm confident I can do an accurate and quick job Flere

$25 USD på 1 dag
(82 bedømmelser)
6.0

96 freelancere byder i gennemsnit $28 på dette job

schoudhary1553

Hello Sir, I am the expert freelancer here. I am on the 6th position through out the world to deliver the quality job. I have deliver here more than 385 + projects with 100% client satisfaction. I have more than 5 Flere

$30 USD på 1 dag
(286 bedømmelser)
7.7
mirniyazuddin92

Dear Sir/Ma'am, I can organize data in excel spreadsheet. If you have questions or doubts about anything, please feel free to ask me. Sincerely, Mir

$30 USD på 1 dag
(373 bedømmelser)
7.7
SBITServices

Hello , I have checked the attached image and understood how data comes to 2 lines. I am ready to start it now and submit it Today. I am very responsible towards my clients and I can complet Flere

$25 USD på 1 dag
(420 bedømmelser)
7.4
asifdwan

Hi there! I've checked the [login to view URL] file. Please award me the job and send me the file. I'm an expert in data entry and data scraping jobs. I've huge experience in working on this type projects. Look forward t Flere

$30 USD på 1 dag
(238 bedømmelser)
7.0
saqibmunir55

hi,i can organize your data in excel file into proper columns contact me thanks.i can start right now

$40 USD på 1 dag
(518 bedømmelser)
7.2
pandey2008

Hello sir, we can do this job and try to finish it asap, plz msg me so we can start work right now, awaiting your [login to view URL]

$35 USD på 1 dag
(560 bedømmelser)
7.5
hdlong66

Hello, You need help organizing data in excel spreadsheet. I can handle this job. My quote is $50 for a work. I need 2 days to deliver completed work. Best regards, Hoang

$50 USD in 2 dage
(152 bedømmelser)
6.9
bilalmaher053

hi, if u can send me pdf i can get data in correct format, thanks..

$20 USD på 1 dag
(174 bedømmelser)
6.2
imraz2016

i am converting expert pdf to excel just contact me and send me file then i will show you sample,thankyou

$26 USD på 1 dag
(161 bedømmelser)
6.2
sheikhakash786

Hi there, I'm a Data entry, Scraping, Excel and Digital Marketing Expert. I have read your project details. I'll organize data in an excel spreadsheet. We are a big team of professionals in the house. We use p Flere

$25 USD på 1 dag
(53 bedømmelser)
6.0
onlinejob247

Hi there, I’ve checked the project details and I can do this perfectly. I have huge experience in working with these projects. Waiting for your quick reply. Look forward to hearing from you soon. Best Regards

$30 USD på 1 dag
(86 bedømmelser)
6.2
satishtl

- Went through the spreadsheet [login to view URL] first four columns and the respective remaining columns in second row could be compared and the final list of 8 columns can be made. Business ID Business Name Email Address Flere

$50 USD in 2 dage
(48 bedømmelser)
6.0
Rizwanmehmood786

hi i am expert i will do 100% accurate I am skillful in Email marketing ,Data Mining, Data Scraping, Data Entry, Data Conversion. Data Typing, Excel Entry. It would be great honor for me work with you.. I can guaran Flere

$25 USD på 1 dag
(91 bedømmelser)
5.9
mediyhnl

Hi, I'm interested with this job and can start working right away. I would like to organize 10 rows as sample of my job if you need that. I'll give you accurate result as the PDF has.

$30 USD på 1 dag
(19 bedømmelser)
5.3
moumitasarker

Hi there, I am applying today for the position of organize data in excel spreadsheet. I have read your project details sir and i understand your project sir. I am very much interested on your job. Also start this work Flere

$150 USD in 5 dage
(70 bedømmelser)
5.5
asadkhan3533

Please review my profile as i have relevant skills and experience required for this project. Kindly send me a message to discuss further. Thanks, Asad Khan

$25 USD på 1 dag
(60 bedømmelser)
5.4
periyannas

Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered twenty four excel vba projects in the past one twenty days. Will use automation as much as possible to do it quickly. Willing t Flere

$45 USD in 3 dage
(55 bedømmelser)
5.4
mariusalex86

Hello. I understand the requirements of this project and I am interested to work on it. I am a reliable freelancer, focused on quality and accuracy. Kindly consider my proposal. Thank you.

$30 USD på 1 dag
(70 bedømmelser)
5.6
maulikaparikh

Hello, I am Maulika from India having a superior experience in data entry. PDF Conversion & All type of Excel work as well as paper document to digital entry. Logo designs & Graphics work as well. Looking forward to Flere

$20 USD på 1 dag
(8 bedømmelser)
5.1
Baibsma

Hi Sir I am working for you to convert data pdf to excel or etc and provide you all usa business contacts as you needed thanks

$25 USD på 1 dag
(13 bedømmelser)
4.8