Not sure I understand what you have. Does the following approximate what your file looks like for the first two stores?: Store Cust1 Cust2 Cust3 Cust4 Cust5 Cust6 Cust7 Cust8 Cust9 Cust10 Cust11 Cust12 1 24 2 5 6 1000 50 80 900 901 902 903 700 2 54 22 58 76 25 90 70 800 801 802 803 600 and you want to end up with a file that looks like?: Cust Store 24 1 2 1 5 1 6 1 etc.
... View more