May 22 2019 05:01 PM
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:
Group A: zips xxxxx, xxxxx, xxxxx,
Group B: yyyyy, yyyyy, yyyyy, yyyyy
May 23 2019 12:55 AM
@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.