Spreadsheet: 183506d1348846124-how-to-re-arrange-data-based-on-the-range-rearrange-help-example
Sheet: Data

 | EXISTING |  |  |  | DESIRED
 | A | B | C |  | A | B | C
 | 693.29 | 127 | 127 |  | 693.29 | 127 | 127
 | 687.04 | 136 | 95.24 |  | 687.04 | 136 | 95.24
 | 686.82 | 136 | 95.24 |  | 686.82 | 136 | 95.24
 | 594.44 | 127 | 127 |  | 594.44 | 127 | 127
 | 580.64 | 124 | 40 |  | 580.64 | 124 | 40
 | 560.4 | 105.16 | 114.3 |  | 560.4 | 105.16 | 114.3
 | 529.7 | 63 | 66.5 |  | 529.7 | 63 | 66.5
 | 524.77 | 63 | 63.5 |  | 524.77 | 63 | 63.5
 | 495.1 | 102 | 102 |  | 495.1 | 102 | 102 |  | Example
 | 494.61 | 102 | 102 |  | 494.61 | 102 | 102 |  | Column A, B and C was rearranged such that their cell values fell within a range of 10
 | 489.68 | 69.2 | 89 |  | 489 | 106.68 | 101.6 |  | All the colored cells were rearranged based on the above.
 | 489 | 106.68 | 101.6 |  | 489.68 | 69.2 | 89
 | 447.71 | 66.7 | 66.7 |  | 447.71 | 66.7 | 66.7
 | 436 | 127.9 | 113 |  | 436 | 127.9 | 113
 | 434.68 | 84 | 50 |  | 429.21 | 127.9 | 113
 | 429.21 | 127.9 | 113 |  | 434.68 | 84 | 50
 | 425.96 | 200.2 | 50 |  | 425.96 | 200.2 | 50
 | 425.96 | 173.8 | 38 |  | 425.96 | 173.8 | 38
 | 420.81 | 99.5 | 35 |  | 420.81 | 99.5 | 35
 | 418.56 | 59.95 | 20 |  | 418.56 | 59.95 | 20
 | 414.12 | 61.12 | 68.28 |  | 414.12 | 61.12 | 68.28
 | 409.57 | 68 | 50 |  | 409.57 | 68 | 50
 | 409.57 | 68 | 50 |  | 409.57 | 68 | 50
 | 409.57 | 68 | 50 |  | 409.57 | 68 | 50
 | 406.27 | 216.2 | 125 |  | 406.27 | 216.2 | 125
 | 406.27 | 140 | 125 |  | 406.27 | 140 | 125
 | 406.27 | 125 | 125 |  | 406.27 | 125 | 125
 | 405.42 | 68 | 50 |  | 405.42 | 68 | 50
 | 404.35 |  | 50 |  | 403.28 | 69.09 | 55
 | 403.28 | 69.09 | 55 |  | 404.35 |  | 50
 | 403.23 | 87 | 40 |  | 403.23 | 87 | 40
 | 393.02 | 177.5 | 50 |  | 393.02 | 177.5 | 50
 | 393.02 | 177.5 | 25 |  | 393.02 | 177.5 | 25
 | 392.77 | 140 | 125 |  | 392.77 | 140 | 125
 | 392 | 63.5 | 63.5 |  | 392 | 63.5 | 63.5
 | 391.17 | 206 | 110 |  | 391.17 | 206 | 110
 | 390.65 | 78.18 | 42 |  | 390.65 | 78.18 | 42
 | 388.5 | 175 | 38 |  | 386.57 | 68 | 50
 | 386.57 | 130 | 52 |  | 388.5 | 175 | 38
 | 386.57 | 130 | 52 |  | 386.57 | 130 | 52
 | 386.57 | 68 | 50 |  | 386.57 | 130 | 52
 | 385.52 | 63.5 | 63.5 |  | 385.52 | 63.5 | 63.5
 | 383.47 | 38 | 30 |  | 383.47 | 38 | 30
 | 383 | 130 | 52 |  | 383 | 130 | 52
 | 379.78 | 91.82 | 76.2 |  | 379.78 | 91.82 | 76.2
 | 378.89 |  | 52 |  | 378.89 |  | 52
 | 378.85 |  | 50 |  | 378.85 |  | 50
 | 378.12 | 59.23 | 45 |  | 378.12 | 59.23 | 45
 | 378.12 | 52.56 | 45 |  | 378.12 | 52.56 | 45
 | 377.98 | 65.5 | 44 |  | 377.98 | 65.5 | 44
 | 368.91 |  | 89 |  | 368.91 |  | 89
 | 367.17 | 137 | 137 |  | 367.17 | 137 | 137
 | 366.65 | 77.9 | 45 |  | 366.65 | 77.9 | 45
 | 366.16 | 106.5 | 89 |  | 366.16 | 95.75 | 89
 | 366.16 | 95.75 | 89 |  | 364.84 | 87 | 37
 | 364.84 | 87 | 37 |  | 364.84 | 87 | 37
 | 364.84 | 87 | 37 |  | 364.84 | 86 | 37
 | 364.84 | 86 | 37 |  | 364.84 | 86 | 37
 | 364.84 | 86 | 37 |  | 364.84 | 86 | 37
 | 364.84 | 86 | 37 |  | 366.16 | 106.5 | 89
 | 362.93 | 101.5 | 89 |  | 362.93 | 101.5 | 89
 | 360.88 | 63 | 44 |  | 360.88 | 63 | 44
 | 354.84 | 68 | 50 |  | 354.84 | 68 | 50
 | 353.68 | 112 | 51 |  | 353.68 | 112 | 51
 | 351.76 | 130 | 52 |  | 351.76 | 130 | 52
 | 351.76 | 68 | 50 |  | 351.76 | 68 | 50
 | 351.76 | 68 | 50 |  | 351.76 | 68 | 50
 | 351.76 | 68 | 50 |  | 351.76 | 68 | 50
 | 351.22 | 71 | 51 |  | 351.22 | 71 | 51
 | 351.01 | 68 | 50 |  | 344.99 | 71 | 51
 | 348.95 |  | 51 |  | 344.99 | 71 | 51
 | 348.85 | 177 | 60 |  | 344.99 | 71 | 51
 | 348.79 | 101.5 | 89 |  | 351.01 | 68 | 50
 | 347.57 |  | 76.2 |  | 348.95 |  | 51
 | 347.29 |  | 50 |  | 348.85 | 177 | 60
 | 347.25 |  | 52 |  | 348.79 | 101.5 | 89
 | 345.93 |  | 76.2 |  | 347.57 |  | 76.2
 | 345.79 | 186.2 | 89 |  | 347.29 |  | 50
 | 345.76 | 189.31 | 76.2 |  | 347.25 |  | 52
 | 345.76 | 189.31 | 76.2 |  | 345.93 |  | 76.2
 | 345.49 | 73.02 | 73.02 |  | 345.79 | 186.2 | 89
 | 344.99 | 71 | 51 |  | 345.76 | 189.31 | 76.2
 | 344.99 | 71 | 51 |  | 345.76 | 189.31 | 76.2
 | 344.99 | 71 | 51 |  | 345.49 | 73.02 | 73.02
 | 344.48 | 112 | 51 |  | 344.48 | 112 | 51
 | 341.94 | 141.59 | 53 |  | 341.94 | 141.59 | 53
 | 341.69 |  | 76.2 |  | 341.69 |  | 76.2
 | 341.69 |  | 76.2 |  | 341.69 |  | 76.2
 | 341.69 |  | 76.2 |  | 341.69 |  | 76.2