Data in Excel from Rows to Colums Below

for detecting the different groups have a look here:

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