Compressing columns

Hi guys,

I have a problem that I'm not sure how to deal with. My data looks like that in the left table (see Attached), And I want to compress the columns by removing blank spaces (see Attached), hopefully I would end up with just one final column, but i need to be able to make sure that if there is 2 or more data on the same row, that they don't overwrite each other.


Thanks Guys