Excel Tip of the Week #378 - Revisiting splitting data

	A	B	C	D	E	G	I	J	K	L	M	N	O	P	Q	R	S	T	U
1	Salesperson	Sale amount	Client	Month	Count	Count	Angie	Brad	Carl	Desmond	Emily	Fatimah	Georgie	Hanna	Imogen	Jack	Katherine	Lucy	Magnolia
2	Imogen	4,827.71	Umbrella Corp	Mar-16	1
3	Emily	9,655.31	Mishima Zaibatsu	Jan-16	1	1	£3,398.81	£9,444.78	£9,551.48	£1,364.29	£9,655.31	£7,801.66	£7,560.74	£2,561.81	£4,827.71	£5,787.18	£1,964.66	£9,421.05	£2,795.97
4	Jack	5,787.18	Umbrella Corp	Aug-16	1	2	£3,039.70	£9,712.30	£4,786.21	£3,232.78	£7,817.72	£6,530.98	£6,642.22	£7,385.26	£9,720.53	£7,530.37	£6,861.77	£4,015.62	£3,774.60
5	Magnolia	2,795.97	Aperture Science	Dec-16	1	3	£9,917.74	£6,839.88	£2,686.26	£5,831.90	£7,073.81	£1,912.53	£3,999.36	£7,525.86	£5,293.15	£9,524.26	£9,794.05	£6,293.67	£7,439.10
6	Emily	7,817.72	LexCorp	Oct-16	2	4	£9,858.58	£9,561.59	£7,794.60		£9,857.69	£1,301.81	£5,538.35	£2,215.08	£6,616.68	£5,378.50	£5,421.04	£9,561.30	£2,235.36
7	Georgie	7,560.74	Black Mesa	Jan-16	1	5	£4,201.73	£7,828.89	£3,026.08		£2,702.91	£7,933.13	£2,191.19	£1,207.17	£3,486.06	£4,565.03	£4,517.84	£1,435.08	£7,832.11
8	Emily	7,073.81	LexCorp	Sep-16	3	6	£3,787.59	£7,032.60			£7,789.40	£6,564.29	£2,839.14	£7,582.39	£9,647.72	£1,676.32	£9,308.19	£6,648.71	£5,952.56
9	Jack	7,530.37	Mishima Zaibatsu	Oct-16	2	7	£7,747.21	£7,503.47			£2,176.93	£6,670.79	£8,099.16	£5,934.03	£9,815.63	£2,430.72	£5,329.86		£5,511.21
10	Fatimah	7,801.66	Aperture Science	Nov-16	1	8					£2,394.39		£7,620.85		£5,131.33	£6,841.36	£4,610.34		£4,690.99
11	Jack	9,524.26	Umbrella Corp	Aug-16	3	9							£2,754.20		£4,989.91	£1,741.60	£4,284.10		£8,593.45
12	Brad	9,444.78	LexCorp	Feb-16	1	10							£6,999.73		£3,082.12	£8,423.82			£1,800.70
13	Brad	9,712.30	Black Mesa	Nov-16	2	11							£9,030.36
14	Fatimah	6,530.98	LexCorp	Nov-16	2
15	Magnolia	3,774.60	LexCorp	Jun-16	2
16	Brad	6,839.88	Mishima Zaibatsu	Mar-16	3
17	Jack	5,378.50	Umbrella Corp	Nov-16	4
18	Hanna	2,561.81	Mishima Zaibatsu	Jul-16	1
19	Imogen	9,720.53	Umbrella Corp	Aug-16	2
20	Angie	3,398.81	LexCorp	Feb-16	1
21	Lucy	9,421.05	Aperture Science	Nov-16	1
22	Fatimah	1,912.53	Aperture Science	Nov-16	3
23	Lucy	4,015.62	Black Mesa	Sep-16	2
24	Katherine	1,964.66	Black Mesa	Jul-16	1
25	Brad	9,561.59	Aperture Science	Mar-16	4
26	Carl	9,551.48	LexCorp	Feb-16	1
27	Brad	7,828.89	Aperture Science	Jan-16	5
28	Brad	7,032.60	LexCorp	Aug-16	6
29	Georgie	6,642.22	Umbrella Corp	Oct-16	2
30	Katherine	6,861.77	Black Mesa	Jun-16	2
31	Jack	4,565.03	Umbrella Corp	Apr-16	5
32	Lucy	6,293.67	Black Mesa	Apr-16	3
33	Hanna	7,385.26	Black Mesa	Sep-16	2
34	Magnolia	7,439.10	Black Mesa	Jul-16	3
35	Angie	3,039.70	Black Mesa	Aug-16	2
36	Katherine	9,794.05	Aperture Science	Nov-16	3
37	Imogen	5,293.15	Umbrella Corp	Nov-16	3
38	Georgie	3,999.36	Mishima Zaibatsu	May-16	3
39	Georgie	5,538.35	Aperture Science	Oct-16	4
40	Fatimah	1,301.81	Black Mesa	May-16	4
41	Angie	9,917.74	Mishima Zaibatsu	Jul-16	3
42	Jack	1,676.32	LexCorp	Jun-16	6
43	Jack	2,430.72	Aperture Science	Aug-16	7
44	Katherine	5,421.04	Black Mesa	Dec-16	4
45	Imogen	6,616.68	Umbrella Corp	Nov-16	4
46	Desmond	1,364.29	Aperture Science	Apr-16	1
47	Georgie	2,191.19	Aperture Science	Jun-16	5
48	Fatimah	7,933.13	Aperture Science	Mar-16	5
49	Magnolia	2,235.36	Aperture Science	Jul-16	4
50	Emily	9,857.69	Aperture Science	May-16	4
51	Katherine	4,517.84	Umbrella Corp	Jan-16	5
52	Georgie	2,839.14	Umbrella Corp	May-16	6
53	Angie	9,858.58	Black Mesa	Nov-16	4
54	Fatimah	6,564.29	Mishima Zaibatsu	Oct-16	6
55	Angie	4,201.73	Black Mesa	Apr-16	5
56	Imogen	3,486.06	LexCorp	Mar-16	5
57	Hanna	7,525.86	Umbrella Corp	Jun-16	3
58	Imogen	9,647.72	LexCorp	Aug-16	6
59	Imogen	9,815.63	Black Mesa	Apr-16	7
60	Emily	2,702.91	LexCorp	Nov-16	5
61	Georgie	8,099.16	Mishima Zaibatsu	Jan-16	7
62	Georgie	7,620.85	LexCorp	Jun-16	8
63	Jack	6,841.36	Black Mesa	Feb-16	8
64	Fatimah	6,670.79	Mishima Zaibatsu	Nov-16	7
65	Emily	7,789.40	Aperture Science	Mar-16	6
66	Katherine	9,308.19	Black Mesa	Aug-16	6
67	Brad	7,503.47	Umbrella Corp	Dec-16	7
68	Angie	3,787.59	Aperture Science	Apr-16	6
69	Carl	4,786.21	Mishima Zaibatsu	Jan-16	2
70	Imogen	5,131.33	Mishima Zaibatsu	Aug-16	8
71	Katherine	5,329.86	LexCorp	Mar-16	7
72	Magnolia	7,832.11	LexCorp	Jul-16	5
73	Magnolia	5,952.56	Aperture Science	Aug-16	6
74	Carl	2,686.26	LexCorp	May-16	3
75	Lucy	9,561.30	Mishima Zaibatsu	Nov-16	4
76	Desmond	3,232.78	Aperture Science	May-16	2
77	Georgie	2,754.20	Aperture Science	Apr-16	9
78	Angie	7,747.21	LexCorp	May-16	7
79	Magnolia	5,511.21	Black Mesa	Feb-16	7
80	Magnolia	4,690.99	Aperture Science	Mar-16	8
81	Hanna	2,215.08	Mishima Zaibatsu	Jun-16	4
82	Magnolia	8,593.45	Umbrella Corp	Nov-16	9
83	Imogen	4,989.91	LexCorp	Nov-16	9
84	Emily	2,176.93	Black Mesa	Feb-16	7
85	Hanna	1,207.17	Umbrella Corp	May-16	5
86	Imogen	3,082.12	Mishima Zaibatsu	Nov-16	10
87	Hanna	7,582.39	Black Mesa	Aug-16	6
88	Carl	7,794.60	Mishima Zaibatsu	Oct-16	4
89	Carl	3,026.08	Aperture Science	Aug-16	5
90	Lucy	1,435.08	Umbrella Corp	Feb-16	5
91	Jack	1,741.60	Mishima Zaibatsu	Aug-16	9
92	Jack	8,423.82	Umbrella Corp	Jun-16	10
93	Hanna	5,934.03	Aperture Science	Jun-16	7
94	Katherine	4,610.34	LexCorp	Mar-16	8
95	Emily	2,394.39	Black Mesa	Nov-16	8
96	Katherine	4,284.10	LexCorp	Mar-16	9
97	Desmond	5,831.90	Umbrella Corp	Dec-16	3
98	Lucy	6,648.71	LexCorp	Oct-16	6
99	Georgie	6,999.73	LexCorp	Apr-16	10
100	Magnolia	1,800.70	Umbrella Corp	Sep-16	10