Forum Discussion
Aggregate values by Year-Month
I am trying to combine the different values of same issue on same month under that month. example- combine all issue1 and issue 2 of August under month-year august 2018 with two colums issue1 and issue2 and same thing should happen for September 2018,............January 2108.
1 Reply
Hi d904490,
As a general solution, maybe you can use CONCATENATEX() and ALLEXCEPT() to concatenate two rows in every date. Please check if it can meet your requirement.
Regards,
Jimmy Tao
