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.

Alteryx test.xlsx

Datasets

Transformation

Accepted answers

mmenth

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

Best,

mmneth

Transposing sheet date.yxzp

All comments

mmenth

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

Best,

mmneth

Transposing sheet date.yxzp

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!

Transposing Sheet Date ddiesel.yxzp

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

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703