I want to do the custom grouping as per my attached document using pivot table.
Much appreciated if anyone can help me on this.
There is no attachment found.
Could you please attach a file with sample data and expected data.
Please attach a file so we can understand your problem.
Thanks a lot for getting back to me. I have attached the excel sheet for your information.
PFA the solution.
Used ValueList for this purpose.
Hope that helps.
Thanks a lot. It does work perfectly.
You marked your response as the correct answer
Retrieving data ...