How to show data horizontally in a Pivot Table

[grromerro]

Hi Community,

I am having issues using the crosstab tool to create a pivot table to show transactions of product for two years lined horizontally instead of vertically. If anybody can help with this, I really appreciate it... Newby here using cross tab tool. 

Thankyou!!! 

[Raj]

Please try using attached Examples with tool
Also add some sample excel Data to help with workflow.

[grromerro]

Hi!, The data is in the text input in the workflow :) Thank you so  much

[Swathi]

Is this what you are after?

[grromerro]

Hi Swathi,

I can't copy and paste the image here, but I have attached the file with what I need to recreate. Basically, it is the data by year as you have it below, but also breaking down the info per month in a column for each year. Is that possible?

Thank you!!

[apathetichell · Accepted solution]

Your order of operations was a bit off. Here's how I'd approach it... IRL I'd probably do something via batch macro to make it a bit more dynamic - but this should get you where you need to go.

[grromerro]

This is Amazing! thank you for sharing and helping to solve this! I really appreciate it!

[grromerro]

Hi Community,

Following with this same case, does any of you know how to make the Summarize tool dynamic so that when a new record for a new month is added in the attached workflow, then it can be included in the pivot table. In the example attached, February transaction is not being captured by the summarize tool,

Thank you so much.