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

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:

Cross Tab.yxmd