I have extracted data from a sql database now the problem is formattin
the data as well as carrying out some functions on the data dependin
on what the data is.
For example I have to format the following data from this
Jan Feb Mar
Branch Qty Price Qty Price Qty Price
Pep 8 7,484.42 18 9,196.67
Shoprite 7 7,628.09 4 7,381.47
Checkers 56 6,410.64 58 19,397.4 6
83.08
PicknPay 33 11,368.1 31 1,915.32
To look like this:
Jan Feb Mar
Branch Qty Price Qty Price Qty Price
Pep 0 0.00 8 7,484.42 18 9,196.67
Shoprite 7 7,628.09 4 7,381.47 0 0.00
Checkers 56 6,410.64 58 19,397.40 6 83.0
PicknPay 0 0.00 100 11,368.10 97
1,915.32
I would like to be able to also insert a column between February an
March and perform the following function (=(D3-B3) / B3) then fill thi
function down for the rest of the rows. Then I would do the sam
between March and April and so forth
Feb Mar
April
Qty Price %Change Qty Price %Change Qty
8 7,484.42 16% 18 9,196.67 7%
17
4 7,381.47 -100% 0 0.00 100%
12
58 19,397.40 78% 6 83.08 33%
4
100 11,368.10 -3% 97 1,915.32 -4%
101
I hope this makes sense.
Kind Regards
PS. for some reason I can't indent the columns to the right places
--
Message posted from
http://www.ExcelForum.com