Create an automation for Google Sheets
- or -
Post a project like this862
£55(approx. $68)
- Posted:
- Proposals: 29
- Remote
- #3441603
- Awarded
Planning and cost engineer (Primavera P6) /Autodesk render/Quantity takeoff/Excel Macros
Cairo
Excel | Google Sheets | Google Apps Script Automation | VBA Macro | Dashboard | Data Analysis
Karachi
Professional Digital Marketer | Web Development | IOS and Android Developer | WordPress | React Native | Video Editor | Graphic Designing
Islamabad
139401561409075270488536505054553945512517568298259221336549189647327764004296566566
Description
Experience Level: Entry
I need to automate a task , i think likely either a Macro or a script needs to be created in Google Sheets.
I have data that comes through in the following ( See EXAMPLE DATA s/sheet attached)
i need the data extracted and some minor amendments and then outputted in the following format( See OUTPUT FILE s/sheet attached)
OUTPUT s/sheet Map column A ( (ordernumber) with column A (Order Number)
OUTPUT s/sheet Map column B ( (Company Name) with column N (Ship to Company Name)
OUTPUT s/sheet Map column C ( Customer Name ) with column K + L combine both fields
OUTPUT s/sheet Map column D ( Address 1 ) with column O ( Ship to Adress line 1 )
OUTPUT s/sheet Map column E ( Address2 ) with column P ( Ship to Adress line 2 )
OUTPUT s/sheet Map column F ( Town ) with column R ( Ship to City )
OUTPUT s/sheet Map column G ( Postcode ) with column T ( Ship to Zip/Postocde )
OUTPUT s/sheet Map column H ( Country ) with column U ( Ship to Country )
OUTPUT s/sheet Map column I ( Telephone) with column AG ( Recipient Phone Number ) With this one also need to be auto formatted from this type of data
+44 7479 539555 to 07479 539555
+44 7874 083421 to 07874 083421
07815151713 leave as 07815151713
7459804671 to 07459 804671
OUTPUT s/sheet Map column J ( Email) with column V ( Email )
If you have any questions please let me know
thanks
I have data that comes through in the following ( See EXAMPLE DATA s/sheet attached)
i need the data extracted and some minor amendments and then outputted in the following format( See OUTPUT FILE s/sheet attached)
OUTPUT s/sheet Map column A ( (ordernumber) with column A (Order Number)
OUTPUT s/sheet Map column B ( (Company Name) with column N (Ship to Company Name)
OUTPUT s/sheet Map column C ( Customer Name ) with column K + L combine both fields
OUTPUT s/sheet Map column D ( Address 1 ) with column O ( Ship to Adress line 1 )
OUTPUT s/sheet Map column E ( Address2 ) with column P ( Ship to Adress line 2 )
OUTPUT s/sheet Map column F ( Town ) with column R ( Ship to City )
OUTPUT s/sheet Map column G ( Postcode ) with column T ( Ship to Zip/Postocde )
OUTPUT s/sheet Map column H ( Country ) with column U ( Ship to Country )
OUTPUT s/sheet Map column I ( Telephone) with column AG ( Recipient Phone Number ) With this one also need to be auto formatted from this type of data
+44 7479 539555 to 07479 539555
+44 7874 083421 to 07874 083421
07815151713 leave as 07815151713
7459804671 to 07459 804671
OUTPUT s/sheet Map column J ( Email) with column V ( Email )
If you have any questions please let me know
thanks
Alex T.
99% (129)Projects Completed
111
Freelancers worked with
101
Projects awarded
57%
Last project
10 Apr 2024
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
There are no clarification messages.
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