Spreadsheet: 717871d1612886183-automatic-sorting-of-multiple-columns-when-new-data-is-entered-time-sheet-testing-cut-down-no-merged-cells
Sheet: Employee List

Where I am trying to get my data sorted |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | My final result I would like to achieve (sorted off of the entry in the yellow column
 | Bbbb |  |  |  |  | = | 1 |  | Hhhh |  |  |  |  | = | 2 |  | Pppp |  |  |  |  | = | 3 |  |  |  |  |  | Bbbb |  |  |  |  | = | 1 |  | Hhhh |  |  |  |  | = | 2 |  | Pppp |  |  |  |  | = | 3
 | Employee Name |  |  |  |  |  |  |  |  |  |  |  | Company |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Employee Name |  |  |  |  |  |  |  |  |  |  |  | Company
1 | a |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | a |  |  |  |  |  |  |  |  |  |  |  | Bbbb
2 | b |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | b |  |  |  |  |  |  |  |  |  |  |  | Bbbb
3 | c |  |  |  |  |  |  |  |  |  |  |  | Hhhh |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | g |  |  |  |  |  |  |  |  |  |  |  | Bbbb
4 | d |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | i |  |  |  |  |  |  |  |  |  |  |  | Bbbb
5 | e |  |  |  |  |  |  |  |  |  |  |  | Hhhh |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5 | c |  |  |  |  |  |  |  |  |  |  |  | Hhhh
6 | f |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | e |  |  |  |  |  |  |  |  |  |  |  | Hhhh
7 | g |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | h |  |  |  |  |  |  |  |  |  |  |  | Hhhh
8 | h |  |  |  |  |  |  |  |  |  |  |  | Hhhh |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | d |  |  |  |  |  |  |  |  |  |  |  | Pppp
9 | i |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | f |  |  |  |  |  |  |  |  |  |  |  | Pppp
10 | j |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10 | j |  |  |  |  |  |  |  |  |  |  |  | Pppp
11 | k |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11 | k |  |  |  |  |  |  |  |  |  |  |  | Pppp
12 | l |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12 | l |  |  |  |  |  |  |  |  |  |  |  | Pppp
13 | m |  |  |  |  |  |  |  |  |  |  |  | Hhhh |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 13 | m |  |  |  |  |  |  |  |  |  |  |  | Hhhh
14 | n |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14 | n |  |  |  |  |  |  |  |  |  |  |  | Bbbb
15 | o |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 15 | o |  |  |  |  |  |  |  |  |  |  |  | Bbbb
16 | p |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 | p |  |  |  |  |  |  |  |  |  |  |  | Bbbb
17 | q |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17 | q |  |  |  |  |  |  |  |  |  |  |  | Bbbb
18 | r |  |  |  |  |  |  |  |  |  |  |  | Hhhh |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18 | r |  |  |  |  |  |  |  |  |  |  |  | Hhhh
19 | s |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 19 | s |  |  |  |  |  |  |  |  |  |  |  | Pppp
20 | t |  |  |  |  |  |  |  |  |  |  |  | Hhhh |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20 | t |  |  |  |  |  |  |  |  |  |  |  | Hhhh
21 | u |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21 | u |  |  |  |  |  |  |  |  |  |  |  | Pppp
22 | v |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 | v |  |  |  |  |  |  |  |  |  |  |  | Bbbb
23 | w |  |  |  |  |  |  |  |  |  |  |  | Hhhh |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23 | w |  |  |  |  |  |  |  |  |  |  |  | Hhhh
24 | x |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24 | x |  |  |  |  |  |  |  |  |  |  |  | Bbbb
25 | y |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25 | y |  |  |  |  |  |  |  |  |  |  |  | Pppp
26 | z |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26 | z |  |  |  |  |  |  |  |  |  |  |  | Pppp
27 | a |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27 | a |  |  |  |  |  |  |  |  |  |  |  | Pppp
28 | b |  |  |  |  |  |  |  |  |  |  |  | Hhhh |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28 | b |  |  |  |  |  |  |  |  |  |  |  | Hhhh
29 | c |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 | c |  |  |  |  |  |  |  |  |  |  |  | Bbbb
30 | d |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30 | d |  |  |  |  |  |  |  |  |  |  |  | Bbbb
31 | e |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31 | e |  |  |  |  |  |  |  |  |  |  |  | Bbbb
32 | f |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32 | f |  |  |  |  |  |  |  |  |  |  |  | Bbbb
33 | g |  |  |  |  |  |  |  |  |  |  |  | Hhhh |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 33 | g |  |  |  |  |  |  |  |  |  |  |  | Hhhh
34 | h |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34 | h |  |  |  |  |  |  |  |  |  |  |  | Pppp
35 | i |  |  |  |  |  |  |  |  |  |  |  | Hhhh |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 35 | i |  |  |  |  |  |  |  |  |  |  |  | Hhhh
36 | j |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36 | j |  |  |  |  |  |  |  |  |  |  |  | Pppp
37 | k |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37 | k |  |  |  |  |  |  |  |  |  |  |  | Bbbb
38 | l |  |  |  |  |  |  |  |  |  |  |  | Hhhh |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38 | l |  |  |  |  |  |  |  |  |  |  |  | Hhhh
39 | m |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39 | m |  |  |  |  |  |  |  |  |  |  |  | Bbbb
40 | n |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40 | n |  |  |  |  |  |  |  |  |  |  |  | Pppp
41 | o |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 41 | o |  |  |  |  |  |  |  |  |  |  |  | Pppp
42 | p |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42 | p |  |  |  |  |  |  |  |  |  |  |  | Pppp
43 | q |  |  |  |  |  |  |  |  |  |  |  | Hhhh |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 43 | q |  |  |  |  |  |  |  |  |  |  |  | Hhhh
44 | r |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44 | r |  |  |  |  |  |  |  |  |  |  |  | Bbbb
45 | s |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 45 | s |  |  |  |  |  |  |  |  |  |  |  | Bbbb
46 | t |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46 | t |  |  |  |  |  |  |  |  |  |  |  | Bbbb
47 | u |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 47 | u |  |  |  |  |  |  |  |  |  |  |  | Bbbb
48 | v |  |  |  |  |  |  |  |  |  |  |  | Hhhh |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 48 | v |  |  |  |  |  |  |  |  |  |  |  | Hhhh
49 | w |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49 | w |  |  |  |  |  |  |  |  |  |  |  | Pppp
50 | x |  |  |  |  |  |  |  |  |  |  |  | Hhhh |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 50 | x |  |  |  |  |  |  |  |  |  |  |  | Hhhh
51 | y |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 51 | y |  |  |  |  |  |  |  |  |  |  |  | Pppp
52 | z |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 52 | z |  |  |  |  |  |  |  |  |  |  |  | Bbbb
53 | a |  |  |  |  |  |  |  |  |  |  |  | Hhhh |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 53 | a |  |  |  |  |  |  |  |  |  |  |  | Hhhh
54 | b |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 54 | b |  |  |  |  |  |  |  |  |  |  |  | Bbbb
55 | c |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 55 | c |  |  |  |  |  |  |  |  |  |  |  | Pppp
56 | d |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 56 | d |  |  |  |  |  |  |  |  |  |  |  | Pppp
57 | e |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 57 | e |  |  |  |  |  |  |  |  |  |  |  | Pppp
58 | f |  |  |  |  |  |  |  |  |  |  |  | Hhhh |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 58 | f |  |  |  |  |  |  |  |  |  |  |  | Hhhh
59 | g |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59 | g |  |  |  |  |  |  |  |  |  |  |  | Bbbb
60 | h |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 60 | h |  |  |  |  |  |  |  |  |  |  |  | Bbbb
61 | i |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 61 | i |  |  |  |  |  |  |  |  |  |  |  | Bbbb
62 | j |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62 | j |  |  |  |  |  |  |  |  |  |  |  | Bbbb
63 | k |  |  |  |  |  |  |  |  |  |  |  | Hhhh |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 63 | k |  |  |  |  |  |  |  |  |  |  |  | Hhhh
64 | l |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 64 | l |  |  |  |  |  |  |  |  |  |  |  | Pppp
65 | m |  |  |  |  |  |  |  |  |  |  |  | Hhhh |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 65 | m |  |  |  |  |  |  |  |  |  |  |  | Hhhh
66 | n |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 66 | n |  |  |  |  |  |  |  |  |  |  |  | Pppp
67 | o |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 67 | o |  |  |  |  |  |  |  |  |  |  |  | Bbbb
68 | p |  |  |  |  |  |  |  |  |  |  |  | Hhhh |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 68 | p |  |  |  |  |  |  |  |  |  |  |  | Hhhh
69 | q |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69 | q |  |  |  |  |  |  |  |  |  |  |  | Bbbb
70 | r |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70 | r |  |  |  |  |  |  |  |  |  |  |  | Pppp
71 | s |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 71 | s |  |  |  |  |  |  |  |  |  |  |  | Pppp
72 | t |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 72 | t |  |  |  |  |  |  |  |  |  |  |  | Pppp
73 | u |  |  |  |  |  |  |  |  |  |  |  | Hhhh |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 73 | u |  |  |  |  |  |  |  |  |  |  |  | Hhhh
74 | v |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 74 | v |  |  |  |  |  |  |  |  |  |  |  | Bbbb
75 | w |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 75 | w |  |  |  |  |  |  |  |  |  |  |  | Bbbb
76 | x |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 76 | x |  |  |  |  |  |  |  |  |  |  |  | Bbbb
77 | y |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 77 | y |  |  |  |  |  |  |  |  |  |  |  | Bbbb
78 | z |  |  |  |  |  |  |  |  |  |  |  | Hhhh |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 78 | z |  |  |  |  |  |  |  |  |  |  |  | Hhhh
79 | a |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 79 | a |  |  |  |  |  |  |  |  |  |  |  | Pppp
80 | b |  |  |  |  |  |  |  |  |  |  |  | Hhhh |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 80 | b |  |  |  |  |  |  |  |  |  |  |  | Hhhh
81 | c |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 81 | c |  |  |  |  |  |  |  |  |  |  |  | Pppp
82 | d |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 82 | d |  |  |  |  |  |  |  |  |  |  |  | Bbbb
83 | e |  |  |  |  |  |  |  |  |  |  |  | Hhhh |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 83 | e |  |  |  |  |  |  |  |  |  |  |  | Hhhh
84 | f |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 84 | f |  |  |  |  |  |  |  |  |  |  |  | Bbbb
85 | g |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 85 | g |  |  |  |  |  |  |  |  |  |  |  | Pppp
86 | h |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 86 | h |  |  |  |  |  |  |  |  |  |  |  | Pppp
87 | i |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 87 | i |  |  |  |  |  |  |  |  |  |  |  | Pppp
88 | j |  |  |  |  |  |  |  |  |  |  |  | Hhhh |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 88 | j |  |  |  |  |  |  |  |  |  |  |  | Hhhh
89 | k |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 89 | k |  |  |  |  |  |  |  |  |  |  |  | Bbbb
90 | l |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 90 | l |  |  |  |  |  |  |  |  |  |  |  | Bbbb
91 | m |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 91 | m |  |  |  |  |  |  |  |  |  |  |  | Bbbb
92 | n |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 92 | n |  |  |  |  |  |  |  |  |  |  |  | Bbbb
93 | o |  |  |  |  |  |  |  |  |  |  |  | Hhhh |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 93 | o |  |  |  |  |  |  |  |  |  |  |  | Hhhh
94 | p |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 94 | p |  |  |  |  |  |  |  |  |  |  |  | Pppp
95 | q |  |  |  |  |  |  |  |  |  |  |  | Hhhh |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 95 | q |  |  |  |  |  |  |  |  |  |  |  | Hhhh
96 | r |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 96 | r |  |  |  |  |  |  |  |  |  |  |  | Pppp
97 | s |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 97 | s |  |  |  |  |  |  |  |  |  |  |  | Bbbb
98 | t |  |  |  |  |  |  |  |  |  |  |  | Hhhh |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 98 | t |  |  |  |  |  |  |  |  |  |  |  | Hhhh
99 | u |  |  |  |  |  |  |  |  |  |  |  | Bbbb |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 99 | u |  |  |  |  |  |  |  |  |  |  |  | Bbbb
100 | v |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 100 | v |  |  |  |  |  |  |  |  |  |  |  | Pppp
101 | w |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 101 | w |  |  |  |  |  |  |  |  |  |  |  | Pppp
102 | x |  |  |  |  |  |  |  |  |  |  |  | Pppp |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 102 | x |  |  |  |  |  |  |  |  |  |  |  | Pppp