I got one table call company

columns: address, suburb, state, post_code

how can I split the address column into the other 3 columns?

for example:
|address|
sydney NSW 2000

split to:
|suburb| |state| |post_code|
sydney NSW 2000

anyone can help me? ASAP