Transfer all values in next sheets and sort

hi all, can you suggest any formula or program on how to transfer this sets of data in another sheets then sort.
below is example table.
A B C D E F
1
2 100
3 101 104 105
4
5
6 102 113 114 115
7
8 103
9 107
10 106
11
12 109 108
13 110 111
14 112
15

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.