Create new dgv from existing dgv

Question

C#, desktop application. I am very new in code. Please some code for me. The name of my dgv is dataGridView1APen and I have a button named ArmyNC. When I shall press the button then the new dgv will appear. Please help me.

The old dgv is like:

Type	Item	Price	Quantity
L	A	3	2
M	B	4	3
L	A	5	7
M	B	6	8
L	A	3	5
S	C	2	9
S	C	1	12

The new dgv will like:

Sl. No.	Type	Item	TotalPrice	TotalQuantity
1	L	A	11	14
2	M	B	10	11
3	S	C	3	21