Sort data of addresses into Table

I’d be able to get them all imported into Access no problem.

It’s getting them into Coloums without doing it manually.

Just wondering if there was an easier way that somebody knew and I didn’t thats all.

Thanks anyway