BiochemBoi95
New Member
- Joined
- Jan 22, 2020
- Messages
- 20
- Office Version
- 365
- 2016
- Platform
- Windows
- Web
I am trying to figure out a way to sort each pair of "Bendability" and "Curvature" columns based on the "Bendability" columns values going from low to high. I have many columns of data and if there is a more automatic way of doing this, that would be awesome.
Here is an example of my data:
Here is an example of how I want it all sorted
Thanks in advance.
Here is an example of my data:
Position | Bendability | Position | Bendability | Position | Bendability | Position | Bendability |
29 | 5.5984 | 29 | 2.3966 | 29 | 4.4758 | 29 | 3.2822 |
30 | 6.3233 | 42 | 4.4428 | 30 | 2.2066 | 30 | 3.7015 |
31 | 6.6904 | 41 | 4.8421 | 31 | 4.0335 | 31 | 5.1261 |
32 | 6.0579 | 34 | 5.1842 | 32 | 7.7086 | 32 | 5.2788 |
33 | 6.195 | 39 | 5.1842 | 33 | 6.8403 | 33 | 4.8691 |
34 | 5.976 | 44 | 5.4089 | 34 | 5.5164 | 34 | 2.5104 |
35 | 5.0215 | 35 | 5.4162 | 35 | 5.4397 | 35 | 4.0335 |
36 | 4.527 | 45 | 5.4856 | 36 | 5.4089 | 36 | 7.7086 |
37 | 2.2066 | 33 | 5.5164 | 37 | 5.4856 | 37 | 6.8403 |
38 | 4.0335 | 46 | 5.5164 | 38 | 5.5164 | 38 | 5.5164 |
39 | 6.6037 | 30 | 5.7576 | 39 | 5.1842 | 39 | 7.0673 |
40 | 6.0579 | 43 | 5.827 | 40 | 5.9708 | 40 | 7.9188 |
41 | 4.8421 | 40 | 5.9708 | 41 | 4.8421 | 41 | 7.2362 |
42 | 6.0705 | 38 | 5.976 | 42 | 6.0705 | 42 | 7.7171 |
43 | 7.4868 | 32 | 6.5263 | 43 | 7.4868 | 43 | 5.3879 |
44 | 4.8802 | 36 | 6.6082 | 44 | 5.8914 | 44 | 4.0247 |
45 | 4.848 | 31 | 7.072 | 45 | 5.8914 | 45 | 5.4856 |
46 | 5.827 | 37 | 7.2998 | 46 | 4.8802 | 46 | 5.5164 |
Here is an example of how I want it all sorted
Position | Bendability |
37 | 2.2066 |
38 | 4.0335 |
36 | 4.527 |
41 | 4.8421 |
45 | 4.848 |
44 | 4.8802 |
35 | 5.0215 |
29 | 5.5984 |
46 | 5.827 |
34 | 5.976 |
32 | 6.0579 |
40 | 6.0579 |
42 | 6.0705 |
33 | 6.195 |
30 | 6.3233 |
39 | 6.6037 |
31 | 6.6904 |
43 | 7.4868 |
Thanks in advance.