Text to columns with multiple rows of text in a cell

[FelixLighter]

Hi,

I'm trying to get the names in row C of the screenshot into two different columns, ideally, I'd like to have the content in every cell from row C listed the way they contend from C1 is now listed in cells D1-4 and E1-4. Let me know if you need more information.

Screenshot URL: Image - TinyPic - Free Image Hosting, Photo Sharing & Video Hosting

 

[Meggesto]

It might take a little work but if you use the Text To Columns Tool on the Data Tab you could use a delimiter such as the space to separate all the names into respective columns. You'd have to rearrange them from that point but if a pattern emerges from how they're broken out you could write a piece of code to reorganize it by looping. Or it might be possible just to do it quickly by hand depending on the size of your list.