how do I move certain pieces of data from a column into another column

[droy58]

using xecel 2008 for mac
I want to take this
Bassett Dalton 9 Brown
Bassett Dalton 9 Green
Bassett Dalton 9 White
Bausch Charlotte 8 Brown
Bausch Charlotte 8 White
Bausch Theodore 10 Brown
Bausch Theodore 10 White

and turn it into this
Bassett Dalton 9 Brown Green White
Bausch Charlotte 8 Brown . . White
Bausch Theodore 10 Brown . . White

 

[Derek Brown]

Hello and welcome to The Board.
I am using Office 2010 and Windows 7, so cannot help where there will be Excel differences between the systems/versions.
However, look at my reply to post:
http://www.mrexcel.com/forum/showthread.php?t=580543

That had data in two columns and I am not sure whether your example was showing one column or four columns. If you can get your data into two columns then the given formulas and method may work for you.

 

[droy58]

My data was showing four columns

 

[Derek Brown]

Then you first need to convert it to two columns by concatenating the first three columns.
For example:
=A2 & " " & B2 & " " & C2