How do I condense, combine and condense info that is in one cell?

First thing you want to do (assuming there are commas separating the items needing parsing like in your example) is to use Excel Text To Column, select delimited by comma, then see what the data looks like and how easy it may be to work with.

Since you only provided a small amount of data, it is kind of hard to project this solution across all the data.

So I separated the data using the excel text to column... Now what? Also the one cell that is now separated was tied to an ID too... I don't know if that is relevant at this point.

If you can't share the entire spreadsheet, then can you show me what the answer you want for the original example provided?

So I wrote what I am trying to do in column E and so I hope it makes sense! Thank you so much!!!
example-of-address-thing.xlsx

So, now I am getting what you are doing.  Try this solution posted by another EE expert:

https://www.experts-exchange.com/questions/28642390/I-HAVE-AN-EXCEL-FILE-WHERE-ALL-OF-THE-DATA-IS-IN-1-ROW-HOW-DO-I-CHANGE-IT.html

I don't understand this option... Is there a way to create a formula to do it?

Make a copy of your tab that has the data you want to parse.  Use the "Substitute" function in the solution on the first cell that has multiple rows (in the cell) and copy down to the end of your data.  Once the ";" has been substituted for the line break that is in the cell, then you can follow his/her solution to parse the data using Text to Columns, then follow the rest of the solution (paste special....).  You should begin to see how the data will come together.  There may be some manual work on your part to get to the final result, but it should be minimal.  Use your imagination.

Please see the attached spreadsheet for moving your question down the road, but not finishing.  My suggestion is you repost the question after completing the steps in the spreadsheet so as to simplify what might be a final answer.
example-of-address-thing.xlsx

Hi Sarah - Here is another expert solution.  Think this very close to what you need after getting the data into multiple rows using the above solution.

https://www.experts-exchange.com/questions/28702175/Combining-Excel-Rows-Into-One-Row.html