Help sorting random column information

[LGreen]

I know only enough excel to be dangerous these days, and need to sort one column of contact information into separate columns. Business, Contact Name, Title, Address1, Address2, City, State, Zip, Business Phone, Email, etc. This is what it looks like now. Text was extracted from a word document originally.

https://cdn1.imggmi.com/uploads/2018/9/25/2b4bfff06ea463006a2851a9817481d5-full.png

Thanks in advance.

 

[Special-K99]

I wont be answering this but your example shows 16 different rows of data before the educational establishment changes.
So does your data change EVERY 16 rows or are some rows missing?

This is prob best sorted via VBA