Cell Data Properties to autofill horizontal cells

I would like to enter a long line of data (text & numbers) into a single cell and have the single cell data populate successive horizontal data fields with automatically. The single cell data would have properties that would correspond to specific properties in the successive fields. The single cell data would remain unchanged. The successive horizontal cells would be looking for a specific piece of the single cell data. I will be happy to include examples if I know what would be needed to help. Thank you.

Here is an example of what I would like to happen. I do not know if this will help. Thank you.