Hi,

I got an excel file from my client, but the problem is I need to re-arrange
it in order to have a clearer view on the data receive. It consist of Hundred
thousand of entries and it is every month the data will come in so that is
why I need a permanent solution to this, pls help.

The data come in as sort by brand but I need it to be sort by outlet so that
I can better view on the individual outlet progress.

It goes like this (pls select on the below and cut & paste it on a excel
file to have a better view):-

Period ending: Jan-05 Feb-05 Mar-05 Apr-05 May-05 Jun-05 Jul-05
---------------------------------------------------------------------------------------------------------------------------------------------------
Stock Item : xxxxxxxxxxxxxx Sales $ 0 0 0 0 0 0 0
Qnty 0 0 0 0 0 0 0
Stock Item : xxxxxxxxxxxxxx
Barcode 50219124 Sales $ 0 0 0 0 0 0 0
Brands Namexxxxxxxx Qnty 0 0 0 0 0 0 0
Outletxxxx Sales $ 0 0 0 0 0 0 0
Qnty 0 0 0 0 0 0 0
Outletxxx Sales $ 0 0 0 0 0 0 0
Qnty 0 0 0 0 0 0 0
outletxxxx Sales $ 0 0 0 0 0 0 0
Stock Item : xxxxx xxxxxxxx Sales
$ 601.83 710.74 1229.26 131.04 114.66 286.43 134.25
Qnty 81 93 150 16 14 32 15
Stock Item : xxxxxxxxxxxxxx
Barcode 12300308793 Sales
$ 601.83 710.74 1229.26 131.04 114.66 286.43 134.25
xxxxx sssssssssss 20 Qnty 81 93 150 16 14 32 15
Outletxxx Sales $ 0 0 0 0 0 0 0
Qnty 0 0 0 0 0 0 0
Outletxxx Sales $ 0 31.24 16.38 0 0 0 8.95
Qnty 0 4 2 0 0 0 1
328PANJANG Sales $ 0 0 8.19 0 0 0 0
Qnty 0 0 1 0 0 0 0
509SERANG Sales $ 7.43 0 0 0 0 0 0
Qnty 1 0 0 0 0 0 0
ALEXANDRA Sales $ 0 7.43 24.57 0 0 0 0
Qnty 0 1 3 0 0 0 0
ALJUNIED Sales $ 0 25.33 8.19 0 0 0 0
Qnty 0 3 1 0 0 0 0
ANCHORAGE Sales $ 0 7.43 8.19 0 0 0 0
Qnty 0 1 1 0 0 0 0
ANGMOKIO Sales $ 0 44.58 8.19 0 0 0 0