How to Selective Categorize Two Dependent Columns from another Table with Conditional Repetition

[clutcher]

HOW DO I DISPLAY A LABEL (E.G. A OR E below) AND SHOW UNIQUE LABEL(s) FOR EACH LOCATION (WITHOUT REPEATING LABELS UNNECESSARILY)? FOR EXAMPLE SHOW LABEL A IN DALLAS, A IN NEW YORK, and A IN MIAMI (in Table 3, last table below). ALSO SHOW ON THE LIST LABEL E FOR DALLAS, NEW YORK AND MIAMI AND MIAMI, IF A LABEL IS NOT ONLY AT A SINGLE LOCATION, SHOW THAT LABEL IN THE TABLE ABOVE AND LOCATION IN COLUMN R, LASTLY ADD THE CONTENT IN COLUMN S

Raw data (column A to H), Note Location is Column B (Table1)

	Location	Code	Name	Quantity	Label	Wt (lbs)	Rank
	Dallas	DER11	Tester1	5,000	A	2,673.75	1
	Dallas	DER11	Tester1	400	E	1190.67	2
	Dallas	DER11	Tester1	60	F	305.52	3
	Dallas	DER11	Tester1	7,000	H	0.25	4
	Dallas	FAE33	Practice2	50	E	117.48	5
	Dallas	FAE33	Practice2	49	F	14.47	6
	Dallas	FAE33	Practice2	43	A	12453.96	7
	Dallas	FAE33	Practice2	8,700	E	4245.62	8
	Dallas	FAE33	Practice2	2,100	F	1633.13	9
	Dallas	FAE33	Practice2	31	F	99.90	10
	Dallas	FAE33	Practice2	43	H	0.85	11
	New York	DER11	Tester1	4	A	12506.52	12
	New York	DER11	Tester1	76	E	5571.72	13
	New York	DER11	Tester1	90	F	1633.07	14
	New York	FAE33	Practice2	633	F	748.98	15
	New York	FAE33	Practice2	34	H	0.40	16
	New York	FAE33	Practice2	42	A	239.93	17
	New York	FAE33	Practice2	23	E	383.96	18
	Miami	DER11	Tester1	444	F	150.87	19
	Miami	DER11	Tester1	746	H	0.64	20
	Miami	FAE33	Practice2	544	A	19.67	21
	Miami	FAE33	Practice2	23	C	0.87	22
	Miami	FAE33	Practice2	10	E	167.37	23

DATA FROM COLUMN L TO 0 (THIS WORKS PERFECTLY) (Table2)

Unique Location	Cum Quantity	Cum Wts	% of Wts
New York	902	21,084.59	49.6%
Dallas	23,476	22,735.61	51.5%
Miami	1,767	339.42	0.8%

DATA FROM COLUMN Q TO U BELOW: THIS IS THE TABLE I NEED HELP POPULATION (WANT TO KNOW BEST FORMULA FOR LABEL COLUMN AND LOCATION COLUMN (Table3)

Label	Location	Cum Quantity	Cum Wts	% of Wts
A
E
H
F
C

 

[Fluff]

Duplicate How to accurately populate table that requires multiple criteria, unique values, with conditional repetition (last label column)

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).