Hi Team,
I have an excel file, which have date in first column(yyyyMM) and i want to group these data’s by year .
Please help me with this.
so, for example if i have 201201,201202,201203 all these together i have to group as 2012.
if i expand these then i could see 3 rows with 201201,201202,201203.