Group or ungroup data in a PivotTable Excel Group or ungroup data in a PivotTable Excel for Office 365 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 More Less Grouping data in a PivotTable can help you show a subset of data to analyze For example you may want to group an unwieldy list of dates or times date and time fields in the PivotTable into quarters and months