I have a mass of data in this format:

Name
Address
City, State, ZIP

I need to convert this info into columns so I can then import it into
my contact management program.

Here's one way, assuming the addresses are an A1:A3, A4:A6, A7:A9, etc.

In B1, put
=OFFSET($A$1,3*ROW()+COLUMN()-5,0)
Then copy B1 across to D1.
Then select B1:D1 and copy down for as many rows as needed.

Modify as needed.