Compare column [Closed]

Report
-
 nash -
Hello,

I have two columns in an excel spreadsheet (2003). I have two columns with partial information in each column. I would like to consolidate the two columns. For examle

column 1 column 2
red
blue
blue
red

I would like to consolidate the data into column 1 so that it appears to be
red
blue
blue
red

Thanks,

2 replies

Posts
191
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
210
Sorry i couldn't understand what you want ????


column 1 column 2
red
blue
blue
red

I would like to consolidate the data into column 1 so that it appears to be
red
blue
blue
red 


what is the difference between
red
blue
blue
red

both parts you have same data

is everything alright with you??? u already have the data you are looking for...