HELP: Transposing Data Structure

[db89]

Hi All,

I am struggling with getting an output that would transpose the values attached in the "Test Template2" in the table format as attached in "OUTPUT" excel files. 

There are many unwanted columns and null rows/cells which has to be excluded to get the structure attached in "OUTPUT" excel file.

Any help on this would be super useful!. 

Thanks,

db89

[gawa · Accepted solution]

hi @db89 

Challenging data cleansing... Though it is not beautiful WF, it at least output the desired format. Please try this WF, and modify it so as to fit to your real data.

[Amit_G_Limbasia]

Dear db89

Please find the workflow for your reference to get your desired output

Modify Select records row as per your requirement

[db89]

Hi @Amit_G_Limbasia 

I think your workflow does great, the only thing its missing out is the '2023 Actual Paymt' column the final output. :)
But thank you for showing the way!

[db89]

@gawa thank you so much for your help with the complex request! :)

[Amit_G_Limbasia]

Thanks @db89 

Attached is the updated workflow, precisely tailored to your requirements. The output perfectly matches your specifications. Please mark as solved if satisfactory.