Previous Topic Next Topic

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

Answer 1 / 2
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 162
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
Answer 2 / 2
nash
Dec 4, 2009 at 10:58 PM
is everything alright with you??? u already have the data you are looking for...
0

Similar discussions

Comparing Two Excel Sheets and copying like data to third sheet
coz2992 -
TrowaD -

11 responses
VBA find column by name and sort
SidK -
bOFILL -

4 responses
Comparing columns and returning value
ll -
kittu -

35 responses
Macro to compare 2 sheets and copy differences
ehusar -
AirMaple -

2 responses
VBA Compare 2 sheets and output difference to 3rd sheet
jmah -
TrowaD -

3 responses
Auto generate serial number in excel based on input value
Raj -
Raj -

14 responses