Just based on the question you have wrote, it sounds like you store multiple data items inside a single column. This causes a situation that when you fetch the data you need to split the data in order to be correctly shown or manipulated.
So it all comes back to design. Using a single column for multiple data items is a choice you will most likely regret later. It introduces unnecessary complexity, like:
- how to split the data when fetched
- how to concatenate data
- how to query the data partially and so on...
So instead of using a single column, if the amount of data items is fixed and they are known, you can use multiple columns. If the amount of items is unknown or you need to add descriptive information to them, use a separate table for the data having a foreign key to this, parent table.