Hey guys,
I've been pulling my hair and trying to work this out, I was wondering if there's a formula that would allow me to remove the extra semi-columns, see data below:
<style type="text/css"><!--br {mso-data-placement:same-cell;}--></style>
<tbody>
;;;;;;VIC;
;;;;;;VIC;
;;;;SA...