Sort phone numbers by state. I have the list of area codes with states next to them (screen shot)

[Transportvehicle]

Hello!

I need help guys, I have the filters at the top but i dont know what to do next. I want to be able to click the filter above the state abbrev column, sort by for example FL (for FLORIDA) and have all of the phone numbers populate on the right that begin with the area code that belongs to that state. How do I do this, seems super complicated. Can someone help my with the code, Im a complete novice! THanks so much for ALLL the help.

Brian @ Vehicle Shipping & Auto Transport Quotes | Auto Shipping Specialists
cardozo.brian@gmail.com

Carrier Phone	Area Code	State/City	State Abbrev.	State
2014220600	201	NJ New Jersey (ne New Jersey incl. Bergen and Hudson counties) <est>	NJ	New Jersey
2025409879	202	DC District of Columbia (all of Washington, DC) <est>	DC	District of Columbia
2039378697	203	CT Connecticut (sw Connecticut incl. Fairfield and New Haven counties) <est>	CT	Connecticut
2039378697	204	MB Manitoba (all of Manitoba) <cst>	MB	Manitoba
2154946050	205	AL Alabama (Birmingham and northern Alabama) <cst>	AL	Alabama
2177418423	206	WA Washington (Seattle area) <pst>	WA	Washington
2177418423	207	ME Maine (all of Maine) <est>	ME	Maine
2398347215	208	ID Idaho (all of Idaho) <mst & pst>	ID	Idaho
2533323913	209	CA California (Stockton and central California) <pst>	CA	California
2676850165	210	TX Texas (San Antonio area) <cst>	TX	Texas
3017958231	212	NY New York (Manhattan area) <est>	NY	New York
3143973175	213	CA California (Downtown Los Angeles area only) <pst>	CA	California
3202599185	214	TX Texas (Dallas area, overlays with 469 and 972) <cst>	TX	Texas
3205589606	215	PA Pennsylvania (Philadelphia only, overlays with 267) <est>	PA	Pennsylvania
3205589606	216	OH Ohio (Cleveland and ne Ohio) <est>	OH	Ohio
3476282715	217	IL Illinois (Springfield and central Illinois) <cst>	IL	Illinois
3476282715	218	MN Minnesota (Duluth and northern Minnesota) <cst>	MN	Minnesota
3605139753	219	IN Indiana (South Bend and northern Indiana) <cst & est>	IN	Indiana
3865279035	224	IL Illinois (Extreme ne Illinois and northwest Chicago suburbs, overlays with 847) <cst>	IL	Illinois

<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>

 

[MiniGangsterPug]

You could just sort them by value a thru Z with the state column, then just scroll down to the state you like, and it will have all the phone numbers in line for you.

 

[Transportvehicle]

You could just sort them by value a thru Z with the state column, then just scroll down to the state you like, and it will have all the phone numbers in line for you.

I dont understand, Im sorry. How would I do that? I want to figure out how I can sort by state and column A and all of the other columns sort to that state. Meaning those area codes are in that state. So the middle column that identifies the cities those area codes are located within that state. I put the state value in front of each of the desccriptions of those cities so when I do click NJ in the state colum those also are produced. However I cant figure out how to get the phone numbers to be sorted also! Im so stressed about this, anything you can do I would really appreciate it, Ill even send you the file. Please anything and thank you!

 

[norulen]

Have you tried your hands at data sorting optionS??
Go to Data Tab>Sort option>Select column you want to sort (In your case it would be State column first) then sort A to Z then Click on Add Level add phone number column and sort smallest to largest

IF you want to sort area code wise also then first level should be state column, then Area code and then phone numbers