How to group an excel data by a specific value in a column

hi goodday, what is the sql query used in the assign activity to group data in Excel by a specific value in a column?

Hi @Yusuf_Rahmaniac,

Try with this,

From a In table _
                    Group a By Key = a.artnr Into Group _
                    Where Group.Count() > 1
                    Select artnr = Key, numbersCount = Group.Count()

hi sir, i want to group data in an excel file based on a value in a column. suppose that value in the column is same for three other rows. so grouping by the value will show only the three rows.