You can move rows into a different group and merge entire groups. For example, in a spreadsheet that tracks items you’re selling online, when you sell an item, you could drag it from the unsold group to the sold group.
To merge two groups, rename one group to the name of the other group. See Rename a group.
Select the rows you want to move.
Tap and hold the selection until it appears to lift, then drag it to a different group.
If you drag the last remaining row out of a group, the two groups are merged and the summary row for the empty group is deleted.
Tip: You can also merge entire groups and their data by changing the name of one group in your table to the name of another existing group.