community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE
SOLVED

Transposing Sheet Date

Meteor

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.

Bolide

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

 

Best,

mmneth

Quasar

Hi @Tanai

 

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.

 

Capture.PNG

Capture.PNG

 

Let us know if this works for you!

 

 

 

 

Quasar

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

Meteor

Thanks a lots @mmenth.

 

That works really good!

 

Best Regards

Meteor

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

Labels