Loading Crosstable

[sumeet-vaidya]

Dear All,

Kindly help in getting the below output from the attached excel file. PFA

Customer	Market Sub Segment	Estimate Version	Month	A	B	C	D	E
0000017533	Pulp	002	AUG	1	2	3	4	5
0000017533	Pulp	002	SEP	6	7	8	9	10
0000017533	Pulp	002	OCT	11	12	13	14	15
0000017533	Pulp	003	AUG	1	2	3	4	5
0000017533	Pulp	003	SEP	6	7	8	9	10
0000017533	Pulp	003	OCT	11	12	13	14	15
0000017535	Pulp	002	AUG	1	2	3	4	5
0000017535	Pulp	002	SEP	6	7	8	9	10
0000017535	Pulp	002	OCT	11	12	13	14	15
0000017535	Pulp	003	AUG	1	2	3	4	5
0000017535	Pulp	003	SEP	6	7	8	9	10
0000017535	Pulp	003	OCT	11	12	13	14	15

hic‌ stalwar1‌

Regards

Sumeet Vaidya

[avinashelite · Accepted solution]

check the attached solution

[avinashelite]

If you have got the answer mark the correct and helpful answers and close this thread

[sumeet-vaidya]

Thanks a lot Avinash!!