Quick Little Function Help...

Brian07002 · #1 07-08-2005, 02:20 PM

Hi,

Basically, what I need to accomplish is this:

I have ran a web query with excel 2003, and the site I ran this query on gave me result like this:

In one row of the workbook, I have:

Product ID:

0001
Item #:
0002
Item #:
0003 ID:
Item #:

What I need to do is remove the cells that say Item #: and then shift the cells up so that the item numbers are the only ones in that row and no spaces between them.

Thanks alot for your help in advance!
-Brian

**Ron Coderre** · #2 07-08-2005, 02:45 PM

Here are 2 ways to do this:

Easiest:
1)Sort the list. (all the "Item #:" will goup together)
2)Select the "Item #:" rows and delete them
Done (but you lose the original order)

OR

Data>Filter>AutoFilter
Product ID dropdown, select "Item #:"

Then
select the displayed "Item #:" rows (all at once)
Edit>GoTo>[Special...]> Visible Cells Only
Edit>Delete>Entire Row
Data>Filter>Show All
Done

Does that help?

Ron

Brian07002 · #3 07-08-2005, 02:56 PM

Hi,

Thank you so much! It worked great!

-Brian

Welcome to the Excel Forum

Forum Statistics