Hi,
I have a problem and didn't find the right answer searching the forums.

The table looks like this:

Birmingham Montgomery Mobile Huntsville Tuscaloosa
Birmingham Montgomery Mobile Huntsville Tuscaloosa
Birmingham Montgomery Mobile Huntsville Tuscaloosa
Birmingham Montgomery Mobile Huntsville Tuscaloosa

The result that I want is (every city name in a different row and the result in a different sheet if it's possible):

Birmingham
Birmingham
Birmingham
Birmingham
Montgomery
Montgomery
Montgomery
Montgomery
Mobile
Mobile
Mobile
Mobile
Huntsville
Huntsville
Huntsville
Huntsville
Tuscaloosa
Tuscaloosa
Tuscaloosa
Tuscaloosa

Can you guys help me?
Thank you!!