|Can you use this method?|
1 - Data...Text To Columns delimited by the space will separate the data in Columns
2 - Copy...PasteSpecial...Transpose will copy the Columns and paste them into Rows
3 - Delete original data
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.