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 responses

Answer 1 / 2
mubashir aziz Posts 190 Registration date Sunday April 12, 2009 Status Member Last seen February 16, 2010 166
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

Auto generate serial number in excel based on Column
Raj_1562 -
TrowaD -

4 responses
Comparing columns and returning value
ll -
kittu -

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

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

11 responses
Converting rows of data in notepad to columns
Need help -
Philgood_FR -

2 responses