Reorganize Text Input into separate fields

[Gilld]

I would like to reorganize the attached data (image) into two fields; City and Postcode - what would be the best way to do this? 

[Gilld]

@LordNeilLord

Very! I'm working from the table attached. 

Thanks!

[LordNeilLord · Accepted solution]

@Gilld

It didn't re-order for me.

Here's the packaged workflow

@LordNeilLord

Part time Tableau, Part Time Alteryx. Full Time Awesome

[Gilld]

Perfect thank you!