I have my geographical data in this format in excel
| Longitude1 | Longitude 2 | ... | |
|---|---|---|---|
| Latitude 1 | Value | Value | ... |
| Latitude 2 | Value | Value | ... |
| ... | ... | ... | ... |
And I would to aggregate/transpose it into the following format:
| Latitude | Longitude | Corresponding value |
|---|---|---|
| Latitude 1 | Longitude 1 | Value |
| Latitude 2 | Longitude 1 | Value |
| ... | ... | ... |
Where my data was essentially a map visualizing the data to now show it in a 3 column summary.
