Convert Data to a Desired Output

[Danah_mr]

Hi all,

I have the following Data and i need to convert it to the Desired Output using Alteryx Designer. Can someone assist me?

Data:

Cost Element	FY	YTD ACT	YTD PLAN	FY PLAN
PURCHASES	2018	30	12	60
PURCHASES	2019	30	14	50
PURCHASES	2020	25	16	40
RENTAL	2020	20	18	60

Desired Output:

	2018	2018	2018	2019	2019	2019	2020	2020	2020
Cost Element	YTD ACT	YTD PLAN	FY PLAN	YTD ACT	YTD PLAN	FY PLAN	YTD ACT	YTD PLAN	FY PLAN
PURCHASES	30	12	60	30	14	50	25	16	40
RENTAL							20	18	60

Thanks!

[Qiu · Accepted solution]

@Danah_mr 
The alteryx will not allow duplicated column Names, so is this acceptable?

[Danah_mr]

Yes, thank you!