Using Excel sheet to group times

Copper Contributor

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

1 Reply

@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.