How can I switch my first row of data with my header?

[Dave_Mosk]

I would like my header to be my first row of data and my first row of data to be my header. This is for the final report export and am not sure if the Reporting nodes can handle this or another way?

Here is how my current data looks. (There are many more rows in the file)

AREA	H9	H10	H11	H12	Type_H9	Type_H10	Type_H11	Type_H11
	TEXT A	TEXT B	TEXT C	TEXT D
Anartica	CE	DE	DE	FG	3	2	2	7

Here is how I want it to look as my final format.

	TEXT A	TEXT B	TEXT C	TEXT D
AREA	H9	H10	H11	H12	Type_H9	Type_H10	Type_H11	Type_H11
Anartica	CE	DE	DE	FG	3	2	2	7

Thank you!

[Felipe_Ribeir0]

Hi @Dave_Mosk 

One way of doing this

[Dave_Mosk]

Nice, that was sneaky!

[Felipe_Ribeir0]

Hi @Dave_Mosk 

If it solved your problem, please accept my answer as a solution to the topic.

Thanks!

[Dave_Mosk]

So my data table looks like that in the middle of the workflow. Your solution inputs the data where the first row is not set to be a header. What would the solution be if the my data is mid workflow?

[Felipe_Ribeir0 · Accepted solution]

Hi @Dave_Mosk 

Using this first part (inside of the container) is one way of doing this