Arrange vertical string into multiple horizontal columns

I have a string of values (header) and sub values which I wish to arrange into columns. The header values are static and always in the same order. The sub values can vary (e.g. sometime 2 entries sometimes 10 entries etc). How would I arrange these values into columns using the same formula?