Header to Coloumn

[Raj_2]

Hi there, Can you get me the header sample Paycode 1 to Paycode col for rows 1 to 5, below is the desired output , similarly on row 6 to 10 as header row 6 data in paycode coloumn.

1	Sample Paycode 1
2	E1	Payment date	Payment amount	Paycode
3	E1	112024	1	Sample Paycode 1
4	E1	112024	1	Sample Paycode 1
5	E1	112024	1	Sample Paycode 1
6	Sample 2
7	E2	Payment date	Payment amount	Paycode
8	E2	112024	1	Sample Paycode 2
9	E2	112024	1	Sample Paycode 2
10	E2	112024	1	Sample Paycode 2

[CoG]

I'm not sure I understand the ask - what is your starting point? Since the workflow was pretty simple, I threw this together to hopefully help guide conversation:

Let me know if this works, or please provide more detail, including sample input used to generate the output you provided. Happy Solving!

[Raj_2]

THanks Andrew for the quick response, just to clarify, col Paycode will be empty in input and what i shared is desired output , so can you tweak and help me 

[CoG]

Would you please include another table (adapted from your sample output above) that showcases the structure of your input? This is what it currently seems like to me, but I don't have confidence that this is correct:

E1	112024	1
E1	112024	1
E1	112024	1
E2	112024	1
E2	112024	1
E2	112024	1