Eddyoftheyear
Technical User
Hi Experts,
I have data result that looks like the below:
Date name Quantity Amount
03/2011 Smith 4 1000
03/2011 John 3 9000
03/2011 Bert 1 1500
I would like to be able to show the result,
if the quantity is more than one, then the quantity will be divided by the amount and spread in the next columns evenly
example,
march April May June
03/2011 Smith 4 1000 250 250 250 250
03/2011 John 3 9000 3000 3000 3000
03/2011 Bert 1 1500 1500
Any suggestions?
I have data result that looks like the below:
Date name Quantity Amount
03/2011 Smith 4 1000
03/2011 John 3 9000
03/2011 Bert 1 1500
I would like to be able to show the result,
if the quantity is more than one, then the quantity will be divided by the amount and spread in the next columns evenly
example,
march April May June
03/2011 Smith 4 1000 250 250 250 250
03/2011 John 3 9000 3000 3000 3000
03/2011 Bert 1 1500 1500
Any suggestions?