How to make a choice in a dropdown box render what appears in anothe4 dropdox box?

Feb 18, 2015 at 3:52 PM
I am currently creating a SP 2013 Site. I have 5 dropdown boxes, when the first one is clicked on (City) it then populates from a lookup table which city is choosen and then fills in the other dropdown boxes. How would I make that happen in SharePoint 2013

I already have a excelsheet that has all the data for the 5 columns.

Would I have to create a lookup list first? here is a example I am trying to replicate.

User chooses the MUNI witch is a dropdown, once I choose ADAMS the other dropdown boxes will auto-populate depending on what MUNI is chosen like below.