Group or ungroup data in a PivotTable – Microsoft Support

November 12, 2024

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 date and time fields in the PivotTable into quarters and months. Windows Mac.

https://support.microsoft.com/en-us/office/group-or-ungroup-data-in-a-pivottable-c9d1ddd0-6580-47d1-82bc-c84a5a340725

Group or ungroup data in a PivotTable – Microsoft Support <body> <h1> Array ( [0] => froup or ungroup data in a pivottable – microsoft support [1] => vroup or ungroup data in a pivottable – microsoft support [2] => broup or ungroup data in a pivottable – microsoft support [3] => hroup or ungroup data in a pivottable – microsoft support [4] => yroup or ungroup data in a pivottable – microsoft support [5] => troup or ungroup data in a pivottable – microsoft support [6] => geoup or ungroup data in a pivottable – microsoft support [7] => gdoup or ungroup data in a pivottable – microsoft support [8] => gfoup or ungroup data in a pivottable – microsoft support [9] => gtoup or ungroup data in a pivottable – microsoft support [10] => g5oup or ungroup data in a pivottable – microsoft support [11] => g4oup or ungroup data in a pivottable – microsoft support [12] => griup or ungroup data in a pivottable – microsoft support [13] => grkup or ungroup data in a pivottable – microsoft support [14] => grlup or ungroup data in a pivottable – microsoft support [15] => grpup or ungroup data in a pivottable – microsoft support [16] => gr0up or ungroup data in a pivottable – microsoft support [17] => gr9up or ungroup data in a pivottable – microsoft support [18] => groyp or ungroup data in a pivottable – microsoft support [19] => grohp or ungroup data in a pivottable – microsoft support [20] => grojp or ungroup data in a pivottable – microsoft support [21] => groip or ungroup data in a pivottable – microsoft support [22] => gro8p or ungroup data in a pivottable – microsoft support [23] => gro7p or ungroup data in a pivottable – microsoft support [24] => grouo or ungroup data in a pivottable – microsoft support [25] => groul or ungroup data in a pivottable – microsoft support [26] => grou- or ungroup data in a pivottable – microsoft support [27] => grou0 or ungroup data in a pivottable – microsoft support [28] => group ir ungroup data in a pivottable – microsoft support [29] => group kr ungroup data in a pivottable – microsoft support [30] => group lr ungroup data in a pivottable – microsoft support [31] => group pr ungroup data in a pivottable – microsoft support [32] => group 0r ungroup data in a pivottable – microsoft support [33] => group 9r ungroup data in a pivottable – microsoft support [34] => group oe ungroup data in a pivottable – microsoft support [35] => group od ungroup data in a pivottable – microsoft support [36] => group of ungroup data in a pivottable – microsoft support [37] => group ot ungroup data in a pivottable – microsoft support [38] => group o5 ungroup data in a pivottable – microsoft support [39] => group o4 ungroup data in a pivottable – microsoft support [40] => group or yngroup data in a pivottable – microsoft support [41] => group or hngroup data in a pivottable – microsoft support [42] => group or jngroup data in a pivottable – microsoft support [43] => group or ingroup data in a pivottable – microsoft support [44] => group or 8ngroup data in a pivottable – microsoft support [45] => group or 7ngroup data in a pivottable – microsoft support [46] => group or ubgroup data in a pivottable – microsoft support [47] => group or umgroup data in a pivottable – microsoft support [48] => group or ujgroup data in a pivottable – microsoft support [49] => group or uhgroup data in a pivottable – microsoft support [50] => group or uhgroup data in a pivottable – microsoft support [51] => group or unfroup data in a pivottable – microsoft support [52] => group or unvroup data in a pivottable – microsoft support [53] => group or unbroup data in a pivottable – microsoft support [54] => group or unhroup data in a pivottable – microsoft support [55] => group or unyroup data in a pivottable – microsoft support [56] => group or untroup data in a pivottable – microsoft support [57] => group or ungeoup data in a pivottable – microsoft support [58] => group or ungdoup data in a pivottable – microsoft support [59] => group or ungfoup data in a pivottable – microsoft support [60] => group or ungtoup data in a pivottable – microsoft support [61] => group or ung5oup data in a pivottable – microsoft support [62] => group or ung4oup data in a pivottable – microsoft support [63] => group or ungriup data in a pivottable – microsoft support [64] => group or ungrkup data in a pivottable – microsoft support [65] => group or ungrlup data in a pivottable – microsoft support [66] => group or ungrpup data in a pivottable – microsoft support [67] => group or ungr0up data in a pivottable – microsoft support [68] => group or ungr9up data in a pivottable – microsoft support [69] => group or ungroyp data in a pivottable – microsoft support [70] => group or ungrohp data in a pivottable – microsoft support [71] => group or ungrojp data in a pivottable – microsoft support [72] => group or ungroip data in a pivottable – microsoft support [73] => group or ungro8p data in a pivottable – microsoft support [74] => group or ungro7p data in a pivottable – microsoft support [75] => group or ungrouo data in a pivottable – microsoft support [76] => group or ungroul data in a pivottable – microsoft support [77] => group or ungrou- data in a pivottable – microsoft support [78] => group or ungrou0 data in a pivottable – microsoft support [79] => group or ungroup sata in a pivottable – microsoft support [80] => group or ungroup xata in a pivottable – microsoft support [81] => group or ungroup cata in a pivottable – microsoft support [82] => group or ungroup fata in a pivottable – microsoft support [83] => group or ungroup rata in a pivottable – microsoft support [84] => group or ungroup eata in a pivottable – microsoft support [85] => group or ungroup dzta in a pivottable – microsoft support [86] => group or ungroup dsta in a pivottable – microsoft support [87] => group or ungroup dwta in a pivottable – microsoft support [88] => group or ungroup dqta in a pivottable – microsoft support [89] => group or ungroup dara in a pivottable – microsoft support [90] => group or ungroup dafa in a pivottable – microsoft support [91] => group or ungroup daga in a pivottable – microsoft support [92] => group or ungroup daya in a pivottable – microsoft support [93] => group or ungroup da6a in a pivottable – microsoft support [94] => group or ungroup da5a in a pivottable – microsoft support [95] => group or ungroup datz in a pivottable – microsoft support [96] => group or ungroup dats in a pivottable – microsoft support [97] => group or ungroup datw in a pivottable – microsoft support [98] => group or ungroup datq in a pivottable – microsoft support [99] => group or ungroup data un a pivottable – microsoft support [100] => group or ungroup data jn a pivottable – microsoft support [101] => group or ungroup data kn a pivottable – microsoft support [102] => group or ungroup data on a pivottable – microsoft support [103] => group or ungroup data 9n a pivottable – microsoft support [104] => group or ungroup data 8n a pivottable – microsoft support [105] => group or ungroup data ib a pivottable – microsoft support [106] => group or ungroup data im a pivottable – microsoft support [107] => group or ungroup data ij a pivottable – microsoft support [108] => group or ungroup data ih a pivottable – microsoft support [109] => group or ungroup data ih a pivottable – microsoft support [110] => group or ungroup data in z pivottable – microsoft support [111] => group or ungroup data in s pivottable – microsoft support [112] => group or ungroup data in w pivottable – microsoft support [113] => group or ungroup data in q pivottable – microsoft support [114] => group or ungroup data in a oivottable – microsoft support [115] => group or ungroup data in a livottable – microsoft support [116] => group or ungroup data in a -ivottable – microsoft support [117] => group or ungroup data in a 0ivottable – microsoft support [118] => group or ungroup data in a puvottable – microsoft support [119] => group or ungroup data in a pjvottable – microsoft support [120] => group or ungroup data in a pkvottable – microsoft support [121] => group or ungroup data in a povottable – microsoft support [122] => group or ungroup data in a p9vottable – microsoft support [123] => group or ungroup data in a p8vottable – microsoft support [124] => group or ungroup data in a picottable – microsoft support [125] => group or ungroup data in a pibottable – microsoft support [126] => group or ungroup data in a pigottable – microsoft support [127] => group or ungroup data in a pifottable – microsoft support [128] => group or ungroup data in a pifottable – microsoft support [129] => group or ungroup data in a pivittable – microsoft support [130] => group or ungroup data in a pivkttable – microsoft support [131] => group or ungroup data in a pivlttable – microsoft support [132] => group or ungroup data in a pivpttable – microsoft support [133] => group or ungroup data in a piv0ttable – microsoft support [134] => group or ungroup data in a piv9ttable – microsoft support [135] => group or ungroup data in a pivortable – microsoft support [136] => group or ungroup data in a pivoftable – microsoft support [137] => group or ungroup data in a pivogtable – microsoft support [138] => group or ungroup data in a pivoytable – microsoft support [139] => group or ungroup data in a pivo6table – microsoft support [140] => group or ungroup data in a pivo5table – microsoft support [141] => group or ungroup data in a pivotrable – microsoft support [142] => group or ungroup data in a pivotfable – microsoft support [143] => group or ungroup data in a pivotgable – microsoft support [144] => group or ungroup data in a pivotyable – microsoft support [145] => group or ungroup data in a pivot6able – microsoft support [146] => group or ungroup data in a pivot5able – microsoft support [147] => group or ungroup data in a pivottzble – microsoft support [148] => group or ungroup data in a pivottsble – microsoft support [149] => group or ungroup data in a pivottwble – microsoft support [150] => group or ungroup data in a pivottqble – microsoft support [151] => group or ungroup data in a pivottavle – microsoft support [152] => group or ungroup data in a pivottanle – microsoft support [153] => group or ungroup data in a pivottahle – microsoft support [154] => group or ungroup data in a pivottagle – microsoft support [155] => group or ungroup data in a pivottagle – microsoft support [156] => group or ungroup data in a pivottabke – microsoft support [157] => group or ungroup data in a pivottabpe – microsoft support [158] => group or ungroup data in a pivottaboe – microsoft support [159] => group or ungroup data in a pivottablw – microsoft support [160] => group or ungroup data in a pivottabls – microsoft support [161] => group or ungroup data in a pivottabld – microsoft support [162] => group or ungroup data in a pivottablr – microsoft support [163] => group or ungroup data in a pivottabl4 – microsoft support [164] => group or ungroup data in a pivottabl3 – microsoft support [165] => group or ungroup data in a pivottable ᰫ microsoft support [166] => group or ungroup data in a pivottable &#u211; microsoft support [167] => group or ungroup data in a pivottable &#i211; microsoft support [168] => group or ungroup data in a pivottable ⏻ microsoft support [169] => group or ungroup data in a pivottable ᾯ microsoft support [170] => group or ungroup data in a pivottable &#8q11; microsoft support [171] => group or ungroup data in a pivottable &#8w11; microsoft support [172] => group or ungroup data in a pivottable ⁷ microsoft support [173] => group or ungroup data in a pivottable ” microsoft support [174] => group or ungroup data in a pivottable &#82q1; microsoft support [175] => group or ungroup data in a pivottable — microsoft support [176] => group or ungroup data in a pivottable &#821q; microsoft support [177] => group or ungroup data in a pivottable &#8211l microsoft support [178] => group or ungroup data in a pivottable &#8211p microsoft support [179] => group or ungroup data in a pivottable &#8211. microsoft support [180] => group or ungroup data in a pivottable – nicrosoft support [181] => group or ungroup data in a pivottable – kicrosoft support [182] => group or ungroup data in a pivottable – jicrosoft support [183] => group or ungroup data in a pivottable – jicrosoft support [184] => group or ungroup data in a pivottable – mucrosoft support [185] => group or ungroup data in a pivottable – mjcrosoft support [186] => group or ungroup data in a pivottable – mkcrosoft support [187] => group or ungroup data in a pivottable – mocrosoft support [188] => group or ungroup data in a pivottable – m9crosoft support [189] => group or ungroup data in a pivottable – m8crosoft support [190] => group or ungroup data in a pivottable – mixrosoft support [191] => group or ungroup data in a pivottable – mivrosoft support [192] => group or ungroup data in a pivottable – mifrosoft support [193] => group or ungroup data in a pivottable – midrosoft support [194] => group or ungroup data in a pivottable – midrosoft support [195] => group or ungroup data in a pivottable – miceosoft support [196] => group or ungroup data in a pivottable – micdosoft support [197] => group or ungroup data in a pivottable – micfosoft support [198] => group or ungroup data in a pivottable – mictosoft support [199] => group or ungroup data in a pivottable – mic5osoft support [200] => group or ungroup data in a pivottable – mic4osoft support [201] => group or ungroup data in a pivottable – micrisoft support [202] => group or ungroup data in a pivottable – micrksoft support [203] => group or ungroup data in a pivottable – micrlsoft support [204] => group or ungroup data in a pivottable – micrpsoft support [205] => group or ungroup data in a pivottable – micr0soft support [206] => group or ungroup data in a pivottable – micr9soft support [207] => group or ungroup data in a pivottable – microaoft support [208] => group or ungroup data in a pivottable – microzoft support [209] => group or ungroup data in a pivottable – microxoft support [210] => group or ungroup data in a pivottable – microdoft support [211] => group or ungroup data in a pivottable – microeoft support [212] => group or ungroup data in a pivottable – microwoft support [213] => group or ungroup data in a pivottable – microsift support [214] => group or ungroup data in a pivottable – microskft support [215] => group or ungroup data in a pivottable – microslft support [216] => group or ungroup data in a pivottable – microspft support [217] => group or ungroup data in a pivottable – micros0ft support [218] => group or ungroup data in a pivottable – micros9ft support [219] => group or ungroup data in a pivottable – microsodt support [220] => group or ungroup data in a pivottable – microsoct support [221] => group or ungroup data in a pivottable – microsovt support [222] => group or ungroup data in a pivottable – microsogt support [223] => group or ungroup data in a pivottable – microsott support [224] => group or ungroup data in a pivottable – microsort support [225] => group or ungroup data in a pivottable – microsofr support [226] => group or ungroup data in a pivottable – microsoff support [227] => group or ungroup data in a pivottable – microsofg support [228] => group or ungroup data in a pivottable – microsofy support [229] => group or ungroup data in a pivottable – microsof6 support [230] => group or ungroup data in a pivottable – microsof5 support [231] => group or ungroup data in a pivottable – microsoft aupport [232] => group or ungroup data in a pivottable – microsoft zupport [233] => group or ungroup data in a pivottable – microsoft xupport [234] => group or ungroup data in a pivottable – microsoft dupport [235] => group or ungroup data in a pivottable – microsoft eupport [236] => group or ungroup data in a pivottable – microsoft wupport [237] => group or ungroup data in a pivottable – microsoft sypport [238] => group or ungroup data in a pivottable – microsoft shpport [239] => group or ungroup data in a pivottable – microsoft sjpport [240] => group or ungroup data in a pivottable – microsoft sipport [241] => group or ungroup data in a pivottable – microsoft s8pport [242] => group or ungroup data in a pivottable – microsoft s7pport [243] => group or ungroup data in a pivottable – microsoft suoport [244] => group or ungroup data in a pivottable – microsoft sulport [245] => group or ungroup data in a pivottable – microsoft su-port [246] => group or ungroup data in a pivottable – microsoft su0port [247] => group or ungroup data in a pivottable – microsoft supoort [248] => group or ungroup data in a pivottable – microsoft suplort [249] => group or ungroup data in a pivottable – microsoft sup-ort [250] => group or ungroup data in a pivottable – microsoft sup0ort [251] => group or ungroup data in a pivottable – microsoft suppirt [252] => group or ungroup data in a pivottable – microsoft suppkrt [253] => group or ungroup data in a pivottable – microsoft supplrt [254] => group or ungroup data in a pivottable – microsoft suppprt [255] => group or ungroup data in a pivottable – microsoft supp0rt [256] => group or ungroup data in a pivottable – microsoft supp9rt [257] => group or ungroup data in a pivottable – microsoft suppoet [258] => group or ungroup data in a pivottable – microsoft suppodt [259] => group or ungroup data in a pivottable – microsoft suppoft [260] => group or ungroup data in a pivottable – microsoft suppott [261] => group or ungroup data in a pivottable – microsoft suppo5t [262] => group or ungroup data in a pivottable – microsoft suppo4t [263] => group or ungroup data in a pivottable – microsoft supporr [264] => group or ungroup data in a pivottable – microsoft supporf [265] => group or ungroup data in a pivottable – microsoft supporg [266] => group or ungroup data in a pivottable – microsoft suppory [267] => group or ungroup data in a pivottable – microsoft suppor6 [268] => group or ungroup data in a pivottable – microsoft suppor5 ) </h1> </body>