Data in Excel from Rows to Colums Below

[Prateek_Valvi]

I have data in sheet in this format:-
fruits mango $10 vegetables tomato $10 car civic $310
bananna $60 potato $60 verna $960
grapes $70 beans $90 figo $970

I want to place the data one beolw the other in this format.

[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