Transpose like Excel - Having Trouble

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!!!

Transpose to Excel Alteryx Workflow.yxmd

Transpose to Excel Sample.xlsx

Transformation

Accepted answers

messi007

@mifrahm,

Please see below:

Hope that helps 🙂

Attached the workflow

Regards

Transpose to Excel Alteryx Workflow.yxmd

All comments

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,

Transpose to Excel Alteryx Workflow.yxmd

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?

Transpose to Excel Alteryx Workflow.yxmd

Quick Links

This months top contributors

AkimasaKajitani 388

mceleavey 388

mbarone 337

Hollingsworth 335

LanisC 335