From: maryann
Date: Wed, 12 May 2010 07:56:52 -0700 (PDT)
Local: Wed, May 12 2010 9:56 pm
Subject: $$Excel-Macros$$ Delete rows and concatenate values.
Dear VBA guru,
I have a table like below:
col A ColB
1 ?
1 ABD
2 ADC
2
2 ADD
I would like to have results
Dear VBA guru,
I have a table like below:
col A ColB
1 ?
1 ABD
2 ADC
2
2 ADD
I would like to have results as:
1 ABD
2 ADC; ADD
In other words, I would like to delete the rows with empty cell and
question marks, or other unwanted values (ideally, the