I have a text string that contains a number of custom fields , the attribute name ends with a ":" and the data ends with a ";" see example below. I want to end up with a column for each attribute in a excel spreadsheet

example of text string

Bike :SS Lightning;NDIS #:;Prefname:Jacob;GEOG CODE:46429;Referred By: Newsletter;NDIS Planner:;Continual EOI:;Customer Type:46021;Date of Birth:;RidingCommunity:Short stature;Support Co ordinator:;notification_billing:1;notification_reports:1;Allied Health Company:;Allied Health Contact:;Allied Health Position:;notification_marketing:1

not all features contain all of the field names. I want to end up with columns Bike, NDIS#, GEOG COde etc and the data for each attribute in a excel spreadsheet. Thanks