Data in Excel from Rows to Colums Below

[ppr (Peter Preuss)]

for detecting the different groups 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…

also it looks that you have to create the input datatable on which you are doing the groupby by splitting the different Excel rows. But this should be done easy by just reefering to the position indexes