Converting text to columns

I have a large data-set with fields that needs to be converted to columns; I have used Excel's "Text-to-Columns" feature using delimiters but there isn't any specific delimiter as mentioned in the options...The data looks like this

What I need is to convert these rows and "One" Column to rows and "Two columns" with "Name" in one and "Company Name" in the other, something like this

If anybody can please help me with this, it would be a great help..

Thanks and best 

Saikat Mondal