total and subtotal in single table

[nvijay5757]

Hi,

my data is like can we show this two tables in single table.

columns: sno, progarm, KD1,Modes

Modes: 1A,2B,3C,4D

in KD1 the values are like K,nK only. 

is it possible to show in single table. please help me.

#modes are total

#tests are total

Modes 1A 2B 3C 4D sub total.

sno	progarm	#Modes	#tests		sno	progarm	Modes
1	IND	14/22	17/42				1A	2B	3C	4D
2	US	15/22	20/30		1	IND	1K	1nK	1K	1K
3	UK	13/22	21/40		2	US	1K	1nK	1K	1nK
4	RSA	13/22	22/30		3	UK	1K	1nK	1K	1K
					4	RSA	2K	1nK	1K	1nK
sno	progarm	#Modes	#tests	Modes
				1A	2B	3C	4D
1	IND	14/22	17/42	1K	1nK	1K	1K
2	US	15/22	20/30	1K	1nK	1K	1nK
3	UK	13/22	21/40	1K	1nK	1K	1K
4	RSA	13/22	22/30	2K	1nK	1K	1nK