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

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

 

[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