Transposing Sheet Date

[Tanai_Goncalves]

Dear all, 

I have a sheet with several months, each month as a separated tab on excel.

And the date is on top of each value, I wish to keep them on side of each value.

I've attached the excel, where the inputs is the real sheet and the output it's what I need.

Any ideas? 

Thanks in advance.

[mmenth · Accepted solution]

You could try using the following workflow for every sheet you want to transpose. 

Best,

mmneth

[ddiesel]

Hi @Tanai_Goncalves

Here's how I'd tackle this one. First identify the sheet names that you want to include. I assumed that you needed the sheets with "Input" on the sheet names. Then I build a macro to transform the data to fit the template you provided.

Let us know if this works for you!

[ddiesel]

@mmenth beat me to it with a good solution as well!

[Tanai_Goncalves]

Thanks a lots @mmenth.

That works really good!

Best Regards

[Tanai_Goncalves]

Thank you very much @ddiesel.

But I am not able yet to run this workflow. I need to update my Alteryx.

I'll sure try it out when updated.

Best Regards