Hello all,
I'm trying to get a record stored for later use from a givenreport for the month of February, 2018. Because the report is Excel based Iwould like to store the data in such a way that Pivot table can be used for anyfuture requirements.
Currently the report looks like this...
However my goal is to achieve something like theimage below in a new sheet:-
Will appreciate a formula more than a Vbascript. But either way it will mean the world to me...
Tk you.
regards,
omair
<!--[if !supportLineBreakNewLine]-->
<!--[endif]-->
I'm trying to get a record stored for later use from a givenreport for the month of February, 2018. Because the report is Excel based Iwould like to store the data in such a way that Pivot table can be used for anyfuture requirements.
Currently the report looks like this...

However my goal is to achieve something like theimage below in a new sheet:-

Will appreciate a formula more than a Vbascript. But either way it will mean the world to me...
Tk you.
regards,
omair
<!--[if !supportLineBreakNewLine]-->
<!--[endif]-->