Multiple Header Rows Data Transformation (ETL)

[Anonymous]

Hi All,

I have the below table as data in excel:

TABLE1:

	Store Name	Store I		Store II		Store III
ProductNo	ProductName	Sale	Profit	Sale	Profit	Sale	Profit
1	ABC	1,000	200	2,000	400	4,000	800
2	XYZ	4,000	800	1,000	200	2,000	400

Required is

RESULT:

ProductNo	ProductName	Store Name	Sale	Profit
1	ABC	Store I	1,000	200
2	XYZ	Store I	4,000	800
1	ABC	Store II	2,000	400
2	XYZ	Store II	1,000	200
1	ABC	Store III	4,000	800
2	XYZ	Store III	2,000	400

Have a nice weekend!

Thanks and BR,

SAK

[maxgro]

maybe this

multi_header_pivot_import.qvw

can helps you

[Anonymous]

I am using PE. Can you please post the script here?

[maxgro]

in the attachment