data sorting

	A	B	C	D
1	State	Capital	State Population	Capital Population
2	Alabama	Montgomery	5,074,296	198,665
3	Alaska	Juneau	733,583	31,973
4	Arizona	Phoenix	7,359,197	1,625,000
5	Arkansas	Little Rock	3,045,637	201,998
6	California	Sacramento	39,029,342	525,041
7	Colorado	Denver	5,839,926	711,463
8	Connecticut	Hartford	3,626,205	120,576
9	Delaware	Dover	1,018,396	38,992
10	Florida	Tallahassee	22,244,823	197,102
11	Georgia	Atlanta	10,912,876	496,461
12	Hawaii	Honolulu	1,440,196	345,510
13	Idaho	Boise	1,939,033	237,446
14	Illinois	Springfield	12,582,032	113,394
15	Indiana	Indianapolis	880,621	882,039
16	Iowa	Des Moines	3,200,517	212,031
17	Kansas	Topeka	509,297	125,963
18	Kentucky	Frankfort	4,512,310	28,595
19	Louisiana	Baton Rouge	4,590,241	222,185
20	Maine	Augusta	1,385,340	18,968
21	Maryland	Annapolis	6,164,660	40,687
22	Massachusetts	Boston	6,981,974	654,776
23	Michigan	Lansing	10,034,113	112,684
24	Minnesota	Saint Paul	5,717,184	307,193
25	Mississippi	Jackson	2,940,057	149,761
26	Missouri	Jefferson City	6,177,957	42,772
27	Montana	Helena	1,122,867	33,120
28	Nebraska	Lincoln	1,967,923	292,657
29	Nevada	Carson City	3,177,772	58,993
30	New Hampshire	Concord	1,395,231	44,006
31	New Jersey	Trenton	9,261,699	90,457
32	New Mexico	Santa Fe	2,113,344	88,193
33	New York	Albany	19,677,151	98,617
34	North Carolina	Raleigh	10,698,973	469,124
35	North Dakota	Bismarck	779,261	74,138
36	Ohio	Columbus	11,756,058	906,528
37	Oklahoma	Oklahoma City	694,800	687,725
38	Oregon	Salem	4,240,137	177,723
39	Pennsylvania	Harrisburg	12,972,008	50,135
40	Rhode Island	Providence	1,093,734	189,692
41	South Carolina	Columbia	5,282,634	137,541
42	South Dakota	Pierre	909,824	14,000
43	Tennessee	Nashville	7,051,339	692,587
44	Texas	Austin	30,029,572	964,177
45	Utah	Salt Lake City	3,380,800	200,478
46	Vermont	Montpelier	647,064	8,002
47	Virginia	Richmond	8,683,619	226,604
48	Washington	Olympia	671,803	55,919
49	West Virginia	Charleston	1,775,156	48,018
50	Wisconsin	Madison	5,892,539	269,196
51	Wyoming	Cheyenne	581,381	65,051
52
53
54	Source: U.S. Census Data 2020-2021
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100