First off, Hello!

I am new to the group so please bear with my stupidity...

I have an Excel SS like this:

Brand Store Number Shipped/Receive Date Item 1 Item 2 Item 3
Alpha 5017 3/19/2007 X
Beta 5027 3/19/2007 X

Etc, etc. there are about 50 rows across.

I'd like to copy the 1st 3 columns to another sheet (which I can do
with a macro, I'd just like to do it as part of a formula)

Then I would like to do some form of if/then statement to copy only
the cells and headers that have data in them to the same new sheet.

For instance, in the above example, I don't want the blank fields to
show.

Any ideas?

If I am being unclear (God knows I hardly understood it and I wrote
it), please let me know.

Thanks in advance!

Grim