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

[clutcher]

HELP: 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, IN NEW YORK, IN MIAMI. 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

	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)

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

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