Google Script for Comma Delimiter/Removing Duplicates/Sorting/Copying to another Sheet

Job ID: 31716227

Budget: ₹600 – ₹1,500 INR

Hello
I need a google script which will:-
1)Copy data and append from Sheet 1 to Sheet 2
2) Separate Rows into separate lines based on commas in Sheet 2
3) Remove Duplicates lines on Sheet 2
4) Sort Data on Sheet 2
5) Delete the copied data from Sheet 1

This should work on Open/ On Edit / Timebased
Related categories: Google Sheets