moving title to header

[TonyMu]

Hello Guys, 

My data looks like this: 

Record	1	2	3	4	5
1	X		X	X
2					X
3	Cost	deadline	Approved	Account	Value
4	30000	2020 Q2	2018 Q4	B132456	2
5	23453	2020 Q1	2019 Q1	A349786	2

How do I move the title to header? (I want Alteryx to interoperate the title as header and not as record anymore) something like below: 

Record	Cost	deadline	Approved	Account	Value
1	30000	2020 Q2	2018 Q4	B132456	2
2	23453	2020 Q1	2019 Q1	A349786	2

[Qiu]

@TonyMu 

Try to be dynamic

[Emil_Kos]

Hi,

I have prepared a workflow for you:

The output: