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

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
SOLVED

Transposing Sheet Date

Highlighted
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