I am willing to bet this is pretty easy for the experts!
If column 1 (UN) contains duplicates I'd like to compare the other rows of the duplicate UN and select either the lower or higher value. Then the output would be one row for each UN
Example below:
| UN | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |
| User 1 | | 00:34:56:75 | 5.2 | 1058 | 9534 | 4.5 | | 00:00:11:32 | 4.1 |
| User 1 | 00:00:08:36 | | | | 6871 | 2.5 | | | 5.6 |
| User 1 | | 00:38:26:65 | 1.2 | 6842 | | | 4.65 | 00:38:26:65 | |
| | | | | | | | | | |
| OUTPUT | | | | | | | | | |
| User 1 | 00:00:08:36 | 00:34:56:75 | 5.2 | 6842 | 9534 | 4.5 | 4.65 | 00:00:11:32 | 5.6 |
