How to split rows into different group

[luo]

Hi folks,

I need to split my data into several group based on month. I tried cross tab and groupby but seems not working. Can I get some help?

Preview of Input:

I think it's doesn't matter how to split. Like split to different column or split to different sheet. But just split by month. 

[luo · Accepted solution]

no need solved. Thanks guys.

[seanmcs]

Hi Luo

Could you share this workflow with me please?

Thank you

Sean

[luo]

@seanmcs Actually, I just use datetime tools to get the month and summerize it.