I'm trying to turn an enormous contact list from a text/word/pdf format into a usable excel sheet. I'm having a big problem because what I need is something like conditionally transposed pasting... Not even sure where to start. Someone tell me if this is hopeless, because doing it manually will take so long that I'm going to have to keep trying till someone solves this or tells me to give up.

Basically I have a sheet that's:

Org name
Street Address
City, State Zip
(area) Phone-Number

and instead I need (humor me that "/" is a new cell column):

Org name / Address / City, State Zip / (area) Phone-Number

And then it gets even a little bit more complicated because there are randomly categories inserted occasionally categories before an org is listed, so sometimes it's:

Region 5
Org name
Street Address
City, State Zip
(area) Phone-Number

Uggg.

If it helps anything, I work at a health non-profit. We do good work, but could really use your help on this...