Groupby & pivoteby functions

Vishal Shashikant Dhuri 0 Reputation points

when groupby & pivoteby features release in excel?

Microsoft 365
Microsoft 365
Formerly Office 365, is a line of subscription services offered by Microsoft which adds to and includes the Microsoft Office product line.
4,336 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Adharsh Santhanam 2,705 Reputation points

    These functions are available in "Excel for Microsoft 365" and not available in older versions of Excel.

    Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.

    0 comments No comments

  2. Jing Zhou 5,210 Reputation points Microsoft Vendor


    Thank you for posting in Q&A forum.

    These functions are currently rolling out to users enrolled in the beta channel for Windows Excel and Mac Excel 

    New aggregation functions: GROUPBY and PIVOTBY - Microsoft Community Hub

    Even if you, as an Insider, have had the opportunity to try it.

    Join the Microsoft 365 Insider Program

    Best regards,

    Jill Zhou

    If the Answer is helpful, please click "Accept Answer" and upvote it.