How to group rows to be listed UNDER the summary row?

I am setting up a check register in Excel. I need to be able to nest rows for things like deposits where there are several items included in that deposit. However, I need them to all be listed UNDER the summary row as well as stay together when sorted. The Group function appears to only expand and collapse ABOVE the summary row. But for example, if I had a $100 deposit, I want it to look like:

DATE	CHECK #	DESCRIPTION					PAYMENT	DEPOSIT
6/1/23	DEP	Bank deposit						$100.00
		DATE	CHECK #	FROM	FOR	AMOUNT
		5/23/23	1000	Amy Carter	Advertising	$25.00
		5/29/23	5221	Casey Johnson	T-shirts	$75.00

Omgosh! I totally missed that! Even when I Google searched it that didn't come up! Thank you!!

I just tried this and the dialog box launcher button is grayed out. Can I not do this within a set table?

Originally Posted by tanasedn

In the table you cannot use subtotal.

How do I group rows in a table to where they'll move as one when I sort?