Fermé

Import Data Excel and Format

Hi all,

I have a spreadsheet for a logbook I need to maintain for work. Unfortunately, the data that work gives me is from a website that I have to copy and paste into a excel spreadsheet and then manually format to get it into the right format.

When I copy and paste the data from the website (see image number 1) and then paste into Excel, it all gets pasted into one column, without commas (see image number 2)

I would like that data to be extracted and placed into separate cells on a different tab of the excel file (see image number 4).

As an example, formatting and extracting the data from the highlighted row on image number 3 -

I would like the data from row #3

Aug 19 2018 773 NICHOLAS CLARK VAISILIVA MCLEOD MEL-LAX 14.25

To then be placed in columns in a different tab and formatted this way:

19/08/2018 773 [login to view URL] MEL-LAX 14.25

As you can see:

1) Column 1 - The date is needed in DD/MM/YYYY format

2) Column 2 - 773 goes in here

3) Column 3 - First name NICHOLAS CLARK goes in here, but truncating the first name so that the name is formatted as [login to view URL]

4) Column 4- MEL-LAX or LAX-BNE etc goes in here

5) Column 5 - The number, in this case 14.25 goes in here

(Noting that the second name VAISILVIA MCLEOD isn't imported)

Any row from the unformatted data (see image number 1) that does't have data, and only shows a ADO, FLY, DDO, SBY etc doesn't get imported into the second tab. All the data that is formatted over to the second tab will be all underneath each other with no spare rows where the was no data,

For example, in image number 1, the data for Aug 19 2018, Aug 20 2018, Sep 02 2018, Sep 03 2018, Sep 09 2018 and Sep 11 2018 would be extracted over to the second tab such that there would be (in this example) 6 rows of data without any spare rows between the data where the DDO, ADO, SBY rows would have been.

I have uploaded a .txt file of an example of the raw data I have copied from the website. This is exactly how the data is presented on the website. Unfortunately, I cannot download as a .cvs or excel file, only the raw data, which makes this project somewhat harder

I AM WILLING TO PAY A FIXED PRICE OF $50 AUD FOR THIS PROJECT

Compétences : Excel, Excel Macros

en voir plus : import data excel mysql, import data excel file perl, import data excel multiple sheet vba, import csv into excel 2016, convert excel to csv comma delimited, excel import csv, convert text file to excel 2016, import text file into excel 2016, excel import data from another workbook vba, how to import data into excel 2016, automatically import data into excel, import data excel quickbooks 2008 invoice, import dates excel format dates dont read dates, filemaker data excel format, php import data excel, import historical data excel format, mysql import data excel 2007, arena 100 import data excel, view import data excel outlook, import data excel quickbooks create invoices

Concernant l'employeur :
( 0 commentaires ) Chermside, Australia

Nº du projet : #19607745

40 freelance font une offre moyenne de $34 pour ce travail

schoudhary1553

Hello, I have gone through your job posting and become very much interested to work with you. I am an expert in this field. I have already completed several projects like this. For evidence you can see my profile. Pl Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 4 jours
(303 Commentaires)
7.8
P0L

Hello, I’m an Excel expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(285 Commentaires)
7.2
Motiurlaw

Okay understood. I have read through your project description and I think I am the right person you are looking for. I have done several similar jobs. You can check my profile here for details at [login to view URL] Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(185 Commentaires)
6.9
polarjin2017

Hello? I have gone through the job details carefully and I am excited to start working on this project. I am ready to start work immediately. I've worked a lot of jobs with it. So I think I can help you if you want. T Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(76 Commentaires)
6.5
hdlan

Hello, I have done a sample for your evaluation. I will complete this project for 50 AUD. Let’s discuss if you’re interested. Best regards, Duong

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(32 Commentaires)
6.2
aubrey03

I am an Excel and VBA specialist with a lot of experience in creating complex automation tools, formulas, databases, queries and macros. You may check some of my projects here: [login to view URL] Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(98 Commentaires)
5.7
sorinacho88

Hello, I have read the instructions and I can easily create a macro that will format the data and move it to the correct place with just one click of a button. I provide free support for all future changes (for ex Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(48 Commentaires)
5.0
xinglong717

Hi. I'm have a lot of experiences in JAVA, C, C#, C++, VB.NET, SQL SERVER , SQL QUERY, .... And I also have experiences in Excel VBA developing and data mining. If you hire me, then I will try my best level for your Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(8 Commentaires)
4.0
paulodayto08

Hi Good Day! A serious freelancer here. I've done a lot of job like this before and I can help you with this project. With my experience as a VBA Macro developer for 8 years I can give you the high quality too Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(21 Commentaires)
3.7
Mickelson

Hi Nice to meet you. I have enough experience in python script. Below the libraries are I used in past project. selenium, pandas, matplotlib, lxml, beautifulsoup, scipy, and other useful libraries. I have written Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(7 Commentaires)
4.4
natalia2010

Hello, my name Natalia. I am working as freelancer since 2009, have over 10 years experience working online in different administration tasks. I hold a BA degree in computer systems as well and have strong skills worki Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 3 jours
(3 Commentaires)
3.2
sergeyprince

Welcome .please send me message .I will send the result immediately. i saw your png. i can do perfectly .I have got 8 years of rich experiences in VBA. I can do VBA programming as fast as you want .I am Data Processi Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(5 Commentaires)
2.0
%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(3 Commentaires)
1.5
TopDesigner315

Hello.I have been working as a secretary for 6 years so I can type quickly and accurately. I have checked your project specification. I am interesting on your project. I can implement your project with fully and c Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(2 Commentaires)
1.5
Zogmeister

I have extensive experience developing and validating VBA macros for the manipulation of data. I work in a healthcare environment, therefore attention to detail accuracy and precision are imperative.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(0 Commentaires)
0.0
umaircareer

hi, I have read your requirement. It is called data scrapping. data from website will go to excel sheet automatically. Then it will be formated as your requirement. I can do this for you and some more features, I'll ad Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 4 jours
(1 Évaluation)
0.0
javierburgos82

I have an excellent use of excel, I´m proactive and I think that I´ll can solve this job in a good time as your needs.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 7 jours
(0 Commentaires)
0.0
ayeshafatimapro

I am expert in Excel and will assist you in this regard. Looking forward to hearing from you. Kindly have a look at my portfolio

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 2 jours
(0 Commentaires)
0.0
patelanjum77

i will do this project. i have 6 years experinced person.i will complete this project within the time limit.

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% AUD en 5 jours
(0 Commentaires)
0.0
mahmutgencel

I have been working as an analyst in many sectors for more than 12 years and my areas of interest are data analysis tools, data mining tools, excel macros, programming, project management etc. I'm new as a freelancer, Plus

%bids___i_sum_sub_32% %project_currencyDetails_sign_sub_33% AUD en 1 jour
(0 Commentaires)
0.0