Create an automation for Google Sheets

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