Hello,
I am trying to consolidate the data below into the table following. I have tried using If, Vlookup, and other functions, but I seem to get stuck every time. The goal is to combine the first column into a list of numbers with the same columns following. Any help is greatly appreciated. If I can provide any other info let me know. Thanks
<tbody>
</tbody>
<tbody>
</tbody>
I am trying to consolidate the data below into the table following. I have tried using If, Vlookup, and other functions, but I seem to get stuck every time. The goal is to combine the first column into a list of numbers with the same columns following. Any help is greatly appreciated. If I can provide any other info let me know. Thanks
* | * | * | * |
* | * | * | * |
* | * | * | * |
4 | UNI GX | 10.05654 | |
5 | UNI GX | 10.05654 | |
6 | UNI GX | 10.05654 | |
7 | UNI GX | 10.05654 | |
9 | UNI GX | 20.46506 | |
10 | UNI GX | 20.46506 | |
14 | TRAP GX | 10.05654 | 10.2929 |
15 | TRAP GX | 7.719677 | 7.542407 |
16 | UNI GX | 7.542407 | |
17 | UNI GX | 7.542407 | |
19 | TRAP GX | 7.719677 | 7.542407 |
20 | UNI GX | 7.542407 | |
* | * | * | * |
* | * | * | * |
23 | UNI GX | 7.542407 | |
24 | UNI GX | 7.542407 | |
25 | UNI GX | 7.542407 | |
26 | UNI GX | 7.542407 | |
* | * | * | * |
31 | UNI GX | 10.05654 | |
32 | UNI GX | 10.05654 | |
33 | UNI GX | 10.05654 | |
35 | UNI GX | 20.46506 | |
* | * | * | * |
37 | UNI GX | 20.46506 | |
38 | UNI GX | 7.542407 | |
39 | TRAP GX | 10.2929 | 10.41933 |
40 | UNI GX | 20.46506 |
<tbody>
</tbody>
* | * | * | * |
4 5 6 7 31 32 33 | UNI GX | 10.05654 | |
9 10 35 37 40 | UNI GX | 20.46506 | |
14 | TRAP GX | 10.05654 | 10.2929 |
15 19 | TRAP GX | 7.719677 | 7.542407 |
16 17 20 23 24 25 26 38 | UNI GX | 7.542407 | |
39 | TRAP GX | 10.2929 | 10.41933 |
<tbody>
</tbody>