How to group by multiple columns and keep all rows

[ppr (Peter Preuss)]

@Anduranauul
referring to your excel creates impression that the different Worksheets are looking like part results but not completely solving the case.

The best would you will share an Excel with a clear sample and description. The best would be 1 Worksheet named input, other Worksheet named output.

Also have a look here:

[HowTo] Overview on different options for grouping data and processing the groups

This HowTo introduces on the different options for grouping data from a datatable in order to process the grouped data. Introduction Grouping data and processing the grouped data is a common scenario e.g. when the grouped data is to aggregate like summing up, find maximum, get the average or concatening items. Lets have a look on following data: [grafik] A possible scenario could be: Create a report containing following information: the region code the sum of CaseCount per RegionCode t…