Excel Output issue

Agarwal_Yash91

Hi All,

I am struggling to get excel output in desired format.

Input:

Product	Region	Currency	FX Currency	Fiscal	Actual	Budget	Forecast
1	Uk	EUR	USD	202108	500	450	550
1	US	USD	USD	202108	850

Output: I am using cross tab tool and get output in below format.

			Actual	Actual	Budget	Budget	Forecast	Forecast
			202108	202109	202108	202109	202108	202109
Product	Region	Currency	USD(FX Currency)	USD(FX Currency)	USD(FX Currency)	USD(FX Currency)	USD(FX Currency)	USD(FX Currency)
1	UK	EUR	500		450		550	700

Please note data in first column starts from row 4 with header in row 3(first 2 two rows blank).

I need to split the files based on FX currency and in current i am missing on header while splitting data using output tool.

Thanks

messi007

@Agarwal_Yash91,

I started with the input below 

I divided the workflow on two part the first one is to get the values of the current month and the second one is to get values for the following one.

Attached the workflow.

Hope this helps! 

Regards

Transpose_20210823.yxmd