How can I delete empty cells in a table so that their data is merged into the same line?

I've got a file that was formatted oddly, so that sometimes entries are separated by newlines, and sometimes they are separated by spaces. When I imported the data from a text file, it turned out as it appears in the attached picture. I'm trying to figure out a way to loop through and change the newline characters into spaces so I can use the same delimiter for the whole file. Does anyone have any advice on how to go about this?

Thanks for your help.

Answer 1

[Image Analyst]

Try this:

t = readtable(fileName)
tNew = rmmissing(t)

If that doesn't work, then attach your data and the code you used to create your table.