TABLES WITH MULTIPLE COLUMN HEADER

[#1]

HI..

pls suggest   how to use cross table with multiple column headers for eg deriving the below table

Location	VALUES	SUB GROUP	GROUP
AP	10	A	PRODUCT 1
MP	11	A	PRODUCT 1
UP	12	A	PRODUCT 1
Kerala	13	A	PRODUCT 1
Delhi	14	A	PRODUCT 1
AP	20	B	PRODUCT 1
MP	21	B	PRODUCT 1
UP	22	B	PRODUCT 1
Kerala	23	B	PRODUCT 1
Delhi	24	B	PRODUCT 1
AP	30	C	PRODUCT 1
MP	31	C	PRODUCT 1
UP	32	C	PRODUCT 1
Kerala	33	C	PRODUCT 1
Delhi	34	C	PRODUCT 1
AP	100	A	PRODUCT2
MP	101	A	PRODUCT2
UP	102	A	PRODUCT2
Kerala	103	A	PRODUCT2
Delhi	104	A	PRODUCT2
AP	121	B	PRODUCT2
MP	122	B	PRODUCT2
UP	123	B	PRODUCT2
Kerala	124	B	PRODUCT2
Delhi	125	B	PRODUCT2
AP	131	C	PRODUCT2
MP	132	C	PRODUCT2
UP	133	C	PRODUCT2
Kerala	134	C	PRODUCT2
Delhi	135	C	PRODUCT2

using input file as

Location	Product1			Product2
	A	B	C	A	B	C
AP	10	20	30	100	121	131
MP	11	21	31	101	122	132
UP	12	22	32	102	123	133
Kerala	13	23	33	103	124	134
Delhi	14	24	34	104	125	135

Thanking You

Vinayagam

[arsal_90]

Please find the attached file

[arsal_90]

Please let me know if you have any problem still

[#4]

Can u please upload excel and explain step by step procedure of above

[arsal_90]

ok give me 10 min i make doc for u

[arsal_90]

Please fin the attached file regarding step by step screen shots if any problem then let me know

[arsal_90 · Accepted solution]

and this is the data file

[#8]

@MUHAMMrAD ARSALAN ASHRAF grt help thank you sir