I have data in the format TableA:
I need to break down data by half yearly and add new column "Q1+Q2". (Want to add columns like highlighted in red in TableB:)
Can any one help on this.
Hi Chandu Sai,
Are you looking for this?
Thanks Madhuri. But I cannot open the workbook.
I created the workbook using 9.3, what version are you on.
I am using 9.0 version.
Retrieving data ...