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>
</tbody>
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>
;;;;;;VIC; | ||
;;;;;;VIC; | ||
;;;;SA;;; | ||
;;;;;;VIC; | ||
;;;;;;VIC; | ||
;;;;;;VIC; | ||
;NSW;NT;QLD;SA;TAS;VIC;WA | ||
;;;;;;VIC; | ||
;;;QLD;;;; <style type="text/css"><!--br {mso-data-placement:same-cell;}--></style>;NSW;;;;;VIC; <style type="text/css"><!--br {mso-data-placement:same-cell;}--></style>;NSW;;;;TAS;VIC; How it should appear: VIC VIC SA VIC VIC VIC
<tbody> </tbody> Kevin |
<tbody>
</tbody>