I have a question related to writing a result to excel. I know how to write a matrix from a single parameter to excel, however I have trouble constructing a single table where all values match. If I have a parameter location(city, xy), where city is a set’s list, while xy has two columns (latitude, longitude), and I would like to combine with parameter Client(city,client), and parameter DistanceClient(city, distance), and parameter ClientDemand(client, poroductdemand), how do I save this data into one table where the rows and columns match?
NOTE: each city has different number of clients: city1 has 4 clients, while, city2 has 8 clients, etc.
How to obtained the following matrix in excel that looks like this:
latitude longitude client distance productdemand
I’m really appreciate your help :)
Best answer by MarcelRoelofsView original