Create groups of repeated numbers in a excel column

Hi guys,

I have a scenario. Consider I have a excel sheet and in column p there is any number e.g 1,2,3 etc. Number 1 is occurring 5 times (i.e 5 rows have value 1 in excel sheet), number 2 is occurring 3 times like that. Now I have to create group of rows for these numbers. For group no 1 , will have 5 rows . similarly there will be groups for all these numbers.

Any approach or ideas how to do this?

@poojakumari can show what is ur expected result?

Values
1
1
1
1
1
2
2
6
8
4
in this example I should create Group1 : 5 rows with value as 1, Group 2 : 2 rows value as 2, Group 3 : 1 row with value 6, group 4: 1 row value 8, group 5: 1 row value as 4.

By Group, do you mean different datatables? Or do you mean different Excel sheets? Different Excel workbooks?

@poojakumari Use sort on number column

on left hand side of assign activity On right hand side of assign activity
dt.DefaultView.Sort ("[URCoulmnName] ASC")

dt is ur datatable variable