Compare column

Closed
rookie - Jul 14, 2009 at 03:46 PM
 nash - Dec 4, 2009 at 10:58 PM
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

mubashir aziz
Posts
190
Registration date
Sunday April 12, 2009
Status
Member
Last seen
February 16, 2010
158
Jul 15, 2009 at 06:08 AM
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

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