1. In column A there is a list of suburb names, state abbreviations, postcodes.
2. There are also some rows that have only the state abbreviation and postcode.
I want to move the state abbreviation and postcode to the cell in the next column immediately adjacent, on the same row.
Theses are the state abbreviations VIC, TAS, NSW, SA, WA, QLD, ACT
See example of original and required in attached file.