Group multiple excel rows just like SQL

Solution 1:

You can try using Power Query to group the columns and do sums on others.

1. Select the range, click Data -> From Other Sources -> From Table/Range. Select my table has headers. Click OK. Power Query Editor will open.
2. On the Home tab (or the Transform tab), select Group by. Select Advance, set the columns to group, set the columns to sum and get average. Click OK. Click

3. Re-order the column to be the way you want. Click Close & Load. You will get the result on the image below. Notice that the result is different from your example as the Order execution times of SBIN are different. So the grouping displays 2 different results (as SQL will also do when using group by).