Spreadsheet: 101718d1299787592-wildcards-in-concatenate-help-putting-it-together-sample2
Sheet: Sheet1

[NAME] (+/-XX%) | 99
Date | Units | Transaction Code | Store Number | Charge Code | Key 1 | Units in Last 365 (per Store Number & Charge Code) | Key2 | Units per Transaction Code per Charge Code per Date | Prior Average Units Per Transaction Code | % of Avg | [NAME] (per B1 setting)
2009-01-05 00:00:00 | 3 | 6484097 | 44.95 | 647550 | 44.95^647550^39818 | 0 | 44.95^6484097^647550^39818 | 4 | n/a | n/a | --
2009-01-05 00:00:00 | 1 | 6484097 | 44.95 | 647550 | 44.95^647550^39818 | 0 | 44.95^6484097^647550^39818 | 4 | n/a | n/a | --
2009-02-24 00:00:00 | 4 | 6302618 | 44.95 | 644444 | 44.95^644444^39868 | 0 | 44.95^6302618^644444^39868 | 4 | n/a | n/a | --
2009-02-26 00:00:00 | 3 | 9090957 | 44.95 | 644444 | 44.95^644444^39870 | 1 | 44.95^9090957^644444^39870 | 7 | 4 | -0.25 | --
2009-02-26 00:00:00 | 3 | 9090957 | 44.95 | 644444 | 44.95^644444^39870 | 1 | 44.95^9090957^644444^39870 | 7 | 4 | -0.25 | --
2009-02-26 00:00:00 | 1 | 9090957 | 44.95 | 644444 | 44.95^644444^39870 | 1 | 44.95^9090957^644444^39870 | 7 | 4 | -0.75 | --
2009-02-26 00:00:00 | 3 | 9090957 | 44.95 | 647550 | 44.95^647550^39870 | 2 | 44.95^9090957^647550^39870 | 3 | 2 | 0.5 | --
2009-03-17 00:00:00 | 4 | 3360842 | 44.95 | 647550 | 44.95^647550^39889 | 3 | 44.95^3360842^647550^39889 | 4 | 2.333333333333333 | 0.7142857142857142 | --
2009-03-17 00:00:00 | 3 | 3360842 | 44.95 | 644444 | 44.95^644444^39889 | 4 | 44.95^3360842^644444^39889 | 3 | 2.75 | 0.09090909090909091 | --
2009-03-19 00:00:00 | 7 | 9035999 | 44.95 | 644444 | 44.95^644444^39891 | 5 | 44.95^9035999^644444^39891 | 7 | 2.8 | 1.5 | [NAME]
2009-03-26 00:00:00 | 4 | 8667763 | 44.95 | 644444 | 44.95^644444^39898 | 6 | 44.95^8667763^644444^39898 | 4 | 3.5 | 0.1428571428571428 | --
2009-04-15 00:00:00 | 7 | 3007781 | 44.95 | 644444 | 44.95^644444^39918 | 7 | 44.95^3007781^644444^39918 | 7 | 3.571428571428572 | 0.9599999999999999 | --
2009-08-25 00:00:00 | 1 | 9276926 | 44.95 | 647550 | 44.95^647550^40050 | 4 | 44.95^9276926^647550^40050 | 7 | 2.75 | -0.6363636363636364 | --
2009-08-25 00:00:00 | 6 | 9276926 | 44.95 | 647550 | 44.95^647550^40050 | 4 | 44.95^9276926^647550^40050 | 7 | 2.75 | 1.181818181818182 | [NAME]
2009-08-25 00:00:00 | 3 | 9276926 | 44.95 | 644444 | 44.95^644444^40050 | 8 | 44.95^9276926^644444^40050 | 3 | 4 | -0.25 | --
2009-08-31 00:00:00 | 6 | 3003503 | 44.95 | 644444 | 44.95^644444^40056 | 9 | 44.95^3003503^644444^40056 | 15 | 3.888888888888889 | 0.5428571428571429 | --
2009-08-31 00:00:00 | 9 | 3003503 | 44.95 | 644444 | 44.95^644444^40056 | 9 | 44.95^3003503^644444^40056 | 15 | 3.888888888888889 | 1.314285714285714 | [NAME]
2009-09-29 00:00:00 | 1 | 1839656 | 44.95 | 644444 | 44.95^644444^40085 | 11 | 44.95^1839656^644444^40085 | 1 | 4.545454545454546 | -0.78 | --
2009-09-29 00:00:00 | 8 | 1839656 | 44.95 | 647550 | 44.95^647550^40085 | 6 | 44.95^1839656^647550^40085 | 8 | 3 | 1.666666666666667 | [NAME]
2010-02-10 00:00:00 | 3 | 9581440 | 44.95 | 647550 | 44.95^647550^40219 | 5 | 44.95^9581440^647550^40219 | 12 | 4.4 | -0.3181818181818182 | --
2010-02-10 00:00:00 | 3 | 9581440 | 44.95 | 647550 | 44.95^647550^40219 | 5 | 44.95^9581440^647550^40219 | 12 | 4.4 | -0.3181818181818182 | --
2010-02-10 00:00:00 | 6 | 9581440 | 44.95 | 647550 | 44.95^647550^40219 | 5 | 44.95^9581440^647550^40219 | 12 | 4.4 | 0.3636363636363635 | --
2010-03-03 00:00:00 | 9 | 3334328 | 44.95 | 647550 | 44.95^647550^40240 | 7 | 44.95^3334328^647550^40240 | 9 | 4.428571428571429 | 1.032258064516129 | [NAME]
2010-03-17 00:00:00 | 3 | 8574722 | 44.95 | 647550 | 44.95^647550^40254 | 8 | 44.95^8574722^647550^40254 | 3 | 5 | -0.4 | --
2009-01-05 00:00:00 | 3 | 6484109 | 45.01 | 644444 | 45.01^644444^39818 | 0 | 45.01^6484109^644444^39818 | 6 | n/a | n/a | --
2009-01-05 00:00:00 | 3 | 6484109 | 45.01 | 644444 | 45.01^644444^39818 | 0 | 45.01^6484109^644444^39818 | 6 | n/a | n/a | --
2009-02-24 00:00:00 | 3 | 6302630 | 45.01 | 644444 | 45.01^644444^39868 | 2 | 45.01^6302630^644444^39868 | 3 | 3 | 0 | --
2009-02-26 00:00:00 | 9 | 9090969 | 45.01 | 644444 | 45.01^644444^39870 | 3 | 45.01^9090969^644444^39870 | 9 | 3 | 2 | [NAME]
2009-02-26 00:00:00 | 1 | 9090969 | 45.01 | 647550 | 45.01^647550^39870 | 0 | 45.01^9090969^647550^39870 | 8 | n/a | n/a | --
2009-02-26 00:00:00 | 3 | 9090969 | 45.01 | 647550 | 45.01^647550^39870 | 0 | 45.01^9090969^647550^39870 | 8 | n/a | n/a | --
2009-02-26 00:00:00 | 4 | 9090969 | 45.01 | 647550 | 45.01^647550^39870 | 0 | 45.01^9090969^647550^39870 | 8 | n/a | n/a | --
2009-03-17 00:00:00 | 3 | 3360854 | 45.01 | 647550 | 45.01^647550^39889 | 3 | 45.01^3360854^647550^39889 | 6 | 2.666666666666667 | 0.1250000000000001 | --
2009-03-17 00:00:00 | 3 | 3360854 | 45.01 | 647550 | 45.01^647550^39889 | 3 | 45.01^3360854^647550^39889 | 6 | 2.666666666666667 | 0.1250000000000001 | --
2009-03-19 00:00:00 | 1 | 9036011 | 45.01 | 644444 | 45.01^644444^39891 | 4 | 45.01^9036011^644444^39891 | 1 | 4.5 | -0.7777777777777778 | --
2009-03-26 00:00:00 | 3 | 8667775 | 45.01 | 644444 | 45.01^644444^39898 | 5 | 45.01^8667775^644444^39898 | 3 | 3.8 | -0.2105263157894736 | --
2009-04-15 00:00:00 | 9 | 3007793 | 45.01 | 644444 | 45.01^644444^39918 | 6 | 45.01^3007793^644444^39918 | 9 | 3.666666666666667 | 1.454545454545455 | [NAME]
2009-08-25 00:00:00 | 1 | 9276938 | 45.01 | 644444 | 45.01^644444^40050 | 7 | 45.01^9276938^644444^40050 | 1 | 4.428571428571429 | -0.7741935483870968 | --
2009-08-25 00:00:00 | 3 | 9276938 | 45.01 | 647550 | 45.01^647550^40050 | 5 | 45.01^9276938^647550^40050 | 11 | 2.8 | 0.0714285714285715 | --
2009-08-25 00:00:00 | 8 | 9276938 | 45.01 | 647550 | 45.01^647550^40050 | 5 | 45.01^9276938^647550^40050 | 11 | 2.8 | 1.857142857142857 | [NAME]
2009-08-31 00:00:00 | 3 | 3003515 | 45.01 | 647550 | 45.01^647550^40056 | 7 | 45.01^3003515^647550^40056 | 6 | 3.571428571428572 | -0.16 | --
2009-08-31 00:00:00 | 3 | 3003515 | 45.01 | 647550 | 45.01^647550^40056 | 7 | 45.01^3003515^647550^40056 | 6 | 3.571428571428572 | -0.16 | --
2009-09-29 00:00:00 | 1 | 1839668 | 45.01 | 644444 | 45.01^644444^40085 | 8 | 45.01^1839668^644444^40085 | 4 | 4 | -0.75 | --
2009-09-29 00:00:00 | 3 | 1839668 | 45.01 | 644444 | 45.01^644444^40085 | 8 | 45.01^1839668^644444^40085 | 4 | 4 | -0.25 | --
2010-02-10 00:00:00 | 3 | 9581452 | 45.01 | 644444 | 45.01^644444^40219 | 8 | 45.01^9581452^644444^40219 | 6 | 3.75 | -0.2 | --
2010-02-10 00:00:00 | 3 | 9581452 | 45.01 | 644444 | 45.01^644444^40219 | 8 | 45.01^9581452^644444^40219 | 6 | 3.75 | -0.2 | --
2010-02-10 00:00:00 | 1 | 9581452 | 45.01 | 647550 | 45.01^647550^40219 | 9 | 45.01^9581452^647550^40219 | 1 | 3.444444444444445 | -0.7096774193548387 | --
2010-03-03 00:00:00 | 3 | 3334340 | 45.01 | 647550 | 45.01^647550^40240 | 7 | 45.01^3334340^647550^40240 | 3 | 3.428571428571428 | -0.1249999999999999 | --
2010-03-17 00:00:00 | 3 | 8574734 | 45.01 | 647550 | 45.01^647550^40254 | 8 | 45.01^8574734^647550^40254 | 3 | 3.375 | -0.1111111111111111 | --