Share via

Groupby & pivoteby functions

Vishal Shashikant Dhuri 0 Reputation points
2024-06-14T05:00:14.54+00:00

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.
5,771 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Adharsh Santhanam 5,925 Reputation points Moderator
    2024-06-14T06:45:41.6833333+00:00

    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
  2. Jing Zhou 7,760 Reputation points Microsoft External Staff
    2024-06-14T08:01:13.5833333+00:00

    Hello,

    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.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.