
Create an automation for Google Sheets
- or -
Post a project like this1405
£55(approx. $73)
- Posted:
- Proposals: 28
- Remote
- #3441603
- Awarded
Professional Digital Marketer | Web Development | IOS and Android Developer | WordPress | React Native | Video Editor | Graphic Designing

Executive Virtual Assistant| IT Consultant | graphics| | Website design | social media management .

Excel | Google Sheets | Dashboards | Google Apps Script | VBA Macro | Automation

TOP PRO - Excel, Word, PowerPoint, VBA, Google Sheet, Outlook, Access, Database, Scripting

139401522748045455394209896650415915365050568298212644635512517527048859221336566566





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% (148)Projects Completed
127
Freelancers worked with
107
Projects awarded
56%
Last project
12 Oct 2025
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