merged header to column

Haokun

Hi I have a data set likes below, the first row has some period header which I want to make those period into one of the column.

				1month			3months
Fund Name	FUM	Inception Date	FMC	Fund	BM	REL	Fund	BM	REL
CITI	100	1/11/1990	1	1.5	6	0.5	2.25	9	0.75
SCB	200	1/11/1990	2	2	4	1	3	6	1.5
JP	300	1/11/1990	1	-1	-4	-0.5	-1.5	-6	-0.75
ALLIANCE	400	1/11/1990	2	-2	-5	-1	-3	-7.5	-1.5

May I know how to transform to the below table?

Fund Name	FUM	Inception Date	FMC	Period	Fund	BM	REL
CITI	100	1/11/1990	1	1month	1.5	6	0.5
SCB	200	1/11/1990	2	1month	2	4	1
JP	300	1/11/1990	1	1month	-1	-4	-0.5
ALLIANCE	400	1/11/1990	2	1month	-2	-5	-1
CITI	100	1/11/1990	1	3months	2.25	9	0.75
SCB	200	1/11/1990	2	3months	3	6	1.5
JP	300	1/11/1990	1	3months	-1.5	-6	-0.75
ALLIANCE	400	1/11/1990	2	3months	-3	-7.5	-1.5

Thanks guys.

AngelosPachis

Oh I see, probably that's my bad, this .yxzp file is a packaged workflow and it is not supported in all Alteryx versions.

I've attached the workflow in a .yxmd and the input file it uses; I've created an .xlsx file which would look similar to your input,

Let me know if it worked for you this time.

example input.xlsx

example.yxmd