hi all,
referring to this topic as starting example http://www.excelforum.com/excel-gene...st-column.html
what i need to do is the exact opposite, so for example i've got this:
Col1 col2 col3 ...
Mississippi Jackson
Florida Orlando Tampa Jacksonville Pensacola Miami
Georgia Atlanta
Louisiana New Orleans Baton Rouge
Alabama Birmingham Mobile Montgomery

and i need this:

Mississippi Jackson
Florida Orlando
Florida Tampa
Florida Jacksonville
Florida Pensacola
Florida Miami
Georgia Atlanta
Louisiana New Orleans
Louisiana Baton Rouge
Alabama Birmingham
Alabama Mobile
Alabama Montgomery


any hint on how to do that?