Convert article with titles in Excel to table of titles

Question

Let's say I have raw text in this structure: :subtitle1; texttext text ;subtitle2; text text ;subtitleN; text text text and I want to create table where column names are "subtitleX" and column values 'text text' - after ;