Excel Expert, Help Required

Hello, I have an excel spreadsheet with 364 rows in it and only 1 column Column A. Within each cell there are around 30 records of print shop names. They are jumbled. I need each shop to be transposed into a seperate column or row base on how the data is. (Company Name, City/State, Phone Number). All the data is on the sheet. I'm guessing their is a way to transpose this data or use a convert text to column function but have not been able to figure it out based on how this data is organized right now. If you are un able to do it with a formula I will need you do do it manually so it is organized and parsed out. I would need the project complete in 7 days or less.