I have created the attached spreadsheet that indicates the travel time between 2 different zip codes. Is there a function/macro that enables me to create different groups of zip codes that are for example 30 minutes or less from each other? For example:
@Julian83 if you change your data layout (which I did using Get & transform with the result on the Query tab) and then generate a pivot table you can do what you need. I grouped the TravelTime column in the pivottable in buckets of 10 minutes, this can easily be changed.