In Excel, I have the following (csv like extract):
groupname origin destination speed winner
client1 paris newyork 100 bob
client1 paris tokyo 200 joe
client1 paris london 100
client1 tokyo paris 213 kok
client1 tokyo newyork 234 lok
client1 newyork paris 233
How would I turn the above into this speed table for Client1?
paris newyork london tokyo
paris 100, bob 100 200, joe
newyork 233
london
tokyo 213, kok 234, lok
I am not sure how to call this, but this is very similar to the distance tables on older maps.
Because I want to report the value in my result table, I am not sure pivot table is the right option. Thanks!