Header to Coloumn

Question

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.

1Sample Paycode 1   2E1Payment datePayment amountPaycode3E11120241Sample Paycode 14E11120241Sample Paycode 15E11120241Sample Paycode 16Sample 2   7E2Payment datePayment amountPaycode8E21120241Sample Paycode 29E21120241Sample Paycode 210E21120241Sample Paycode 2

CoG · Answer

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:

E11120241E11120241E11120241E21120241E21120241E21120241

Raj_2 · Answer

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 · Answer

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!

Sample Workflow.yxmd