Transpose & Grouping

[digitalmemo]

Hi Everyone, hope I can get help from this problem:

Name     Month    Price        
One        01          10.00
One        02          11.00
Two        01          13.00
Two        02           14.00
 
I've tried a couple of transpose and cross tab rule but I can't get the result that I want. 

Name     01          02
One       10.00     11.00  
Two        13.00    14.00

[JoshKushner · Accepted solution]

You can get your desired result by using the Cross Tab tool in the below way.

I've also attached a sample file.

Flow:

Cross Tab:

[digitalmemo]

Thank you @JoshKushner this gave me a lot of idea. 

A follow up question, I added a new field called count

Name       Month         Count          Price
One             1                  2                10.00
One             2                  4                 11.00
Two             1                  3                 13.00
Two             2                  6                 14.00

And I want it to be this output:

Name     Count            1              Count             2
One            2           10.00              11.00           4
Two            3           13.00              14.00           6

Through your sample, I got it right but I want to know if my logic for building the solution is correct.

I want to know if this is the simplest way to do my desire output. Thank you again.

[JoshKushner · Accepted solution]

That looks absolutely right! I've included and attached my replication of what you have below:

(I've renamed the count columns to align with each month in the Join tool)

Flow:

Result:

Join:

[digitalmemo]

Thank you very much! This solution saved me a lot! :)