Repeating Headers for Each row using Alteryx Designer

[Tej_Singh]

Hi Team,

I have the below data and want to repeat header (First 2 rows for each Org row). Output required shown below. 

Input data shared in excel as an attachment.

Can we achieve this in Alteryx Designer?

Input:

Org	Particulars	Val1	Val2	Val3	Val4	Val5
	Check 1
A	Over-writing records	1	2	3	4	5
B	Over-writing records	11	12	13	14	15
C	Over-writing records	21	22	23	24	25

Output:

A	Org	Particulars	Val1	Val2	Val3	Val4	Val5
A	A	Check 1
A	A	Over-writing records	1	2	3	4	5
B	Org	Particulars	Val1	Val2	Val3	Val4	Val5
B	B	Check 1
B	B	Over-writing records	11	12	13	14	15
C	Org	Particulars	Val1	Val2	Val3	Val4	Val5
C	C	Check 1
C	C	Over-writing records	21	22	23	24	25

[Felipe_Ribeir0]

Hi @Tej_Singh 

One way of doing this

[Tej_Singh]

Thanks for the solution, @Felipe_Ribeir0 

[binuacs]

@Tej_Singh One way of doing this with the batch macro