I have several columns in a spreadsheet and the spreadsheet ahs to be Group
by One column and Sort by Another one. I can use Data Sort option and sort
the whole spread sheet with respect to particular column but I cannot group
it.

Grouping means all the data with similar values should be together.
If there are 5 rows with values like 33, 44, 33, 44, 22 then the both the
rows of 33 should be together and 44 should be together too.