Hello, I have these records
NoticeNr Coordinate ListID
1130 56-41N 1
1130 56-30N 2
1130 001-57W 3
1130 001-29W 4
1134 52-15.0N 002-30.5E
I would like to aggregate the NoticeNr 1130 to two records having the following coordinates (56-41N 001-57W ) and (56-30N 001-29W). The goal is to have it as NoticeNr 1134, so the order (Listid asc) of lat long values in the table should be respected. What is the best way to do so? It is also possible that there are more than two records for longitude and latitude.