all data in 1 column , what formula can I use to populate data in separate columns?

[djmatok]

I am trying to populate the following and I dont know what formula to use.The data is all over the place and I want to have the title/ Master/ publisehr / writers in separate column but the original data is in a list with all these labels in one column . what formula could I best use to accomplish my objective?

[djmatok]

can someone help me with a formula that will be able to give me each data in a separate column?