Is there a way to automatically organise my data into groups?

[eimmasdavies]

I have a spreadsheet full of data from some experiments. I have percentage values, ranging from 0-60% and I want to group these into subgroups such as 0-5, 6-10, 11-15% etc. Example is below:

Percentage Depth	Depth Group
3.7	0-5
7.4	6-10
11.1	11-15

Is there a way I can automatically put these values into their respective groups as opposed to having to do it myself manually?

[#2]

@eimmasdavies 

Perhaps PivotTable on source (without adding to data model) and group in it.