How do I convert a delimited list to a multicolumn table in excel?

How do I convert a delimited list to a multicolumn table in excel?

I have a list like this:
Friut;Taste;Color;Other;Apple;Good;Red and Blue;1;Orange;Really
Good;Orange;12
And I want to convert it by selecting every 4 delimitations and turning
them into rows like this:
Fruit Taste Color Other
Apple Good Red and G.1
Orange Really Go.Orange 12
How is this possible with Libreoffice (preferred), Openoffice, or Excel?