Transpose like Excel - Having Trouble

[mifrahm]

Hi! I am looking to make an app out of "What I copy" sheet every month to look like "What I want" sheet. I am unsure of how to make it work so that the format looks the same and if I were to let the app pick the file for next month to not result in any error. Attaching the relevant excel sheet and where I have gotten so far with the workflow. Can someone please help?

Thanks!!!

[messi007]

@mifrahm,

I don't think is a matter of transpose only.

I have done the workflow for two types I'll let you complete the third

Attached the workflow,

Hope that helps!

Regards,

[mifrahm]

Hi @messi007 - thank you so much. This brings me much closer to the "end result" that I wouldn't have guessed on my own otherwise. I still noticed a few missing columns. 

The pink container is what I want. 

The browse tool from the workflow you created (with the addition I added) has only one value column. 

I made a few tweaks to the pink container for clarity. Does it make sense? 

[messi007 · Accepted solution]

@mifrahm,

Please see below:

Hope that helps 🙂

Attached the workflow

Regards

[mifrahm]

Thank you for responding so quickly! I am going to wrap my head around some of the new changes and let you know. On a quick glance, its headed in the direction I wanted.

Much appreciated! @messi007 

[messi007]

@mifrahm,

Happy to help 🙂

If this solves your issue please mark the answer as correct. It will help others 🙂

Best Regards,

[mifrahm]

This ended up working out. Thank you so much!!!!!