collect data from spread sheet

Hi I have 2 spreadsheets attached that i need updated. Spreadsheet named part 1 have 900+ data in a line which have number combinations from 1 until 49 in a row of six number and an additional random number(yellow) between 1 to 49. What i need is that each row need to be from lowest to the highest, you need to do this with all the rows. Then you have to sort the combinations from the lowest to the highest. And save it in sheet 2 named complete. Accuracy is important and will be checked. Spreadsheet named part 2 have 600+ data and needs to be the same as above mentioned. Spreadsheet named part 3 is a bit tricky and need more work. Please see attached document which explain in more detail if you have any questions please PMB. Complete the task so i can see how well you have done and i will select you to do more similar work. Please state in your bid yippeee. if not your bid wont be considered. Best of luck to all.