How to delete empty rows in multiple column?

[x15]

Hi guys,
How to delete empty rows in multiple column? Here's the example of the data..


PSW101 PSW102 PSW202 PSW201 PSW301 PSW302
0
0 0
1
0
0
2
0 0
0
0
0
1
0 0
0

[Ron de Bruin]

I see no empty rows ? but rows with a 0

Start here
http://www.rondebruin.nl/delete.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl


"x15" <[email protected]> wrote in message news:[email protected]...
>
> Hi guys,
> How to delete empty rows in multiple column? Here's the example of the
> data..
>
>
> PSW101 PSW102 PSW202 PSW201 PSW301 PSW302
> 0
> 0 0
> 1
> 0
> 0
> 2
> 0 0
> 0
> 0
> 0
> 1
> 0 0
> 0
>
>
> --
> x15
> ------------------------------------------------------------------------
> x15's Profile: http://www.excelforum.com/member.php...o&userid=29510
> View this thread: http://www.excelforum.com/showthread...hreadid=492120
>

[x15]

[QUOTE=x15]Hi guys,
How to delete empty rows in multiple column? Here's the example of the data..


Pls see attachment for the sample. Thanks & have a nice day

hmm... can't see the attachment, here's the link of the screenshot..
http://i9.photobucket.com/albums/a98.../emptcolum.jpg

[STEVE BELL]

Not sure what defines an empty row:
Absolutely no entries in any cell (including 0's)
or
If only numeric values in cells and you don't want any rows adding to 0

There are many ways to do this - but you need to first carefully define what
excel needs to find in order to keep a row - or what it needs to find to
delete a row.

You can cycle through all rows (bottom up) and check each row & decide.

You can create a dummy column with a simple formula that equates to some
value.
Copy/Paste Values on this column.
Do a replace all on the value you don't want (replace with nothing entered
in the replace with.
Edit > GoTo Special > Blank Cells
Delete rows

Or you can get more creative...
--
steveB

Remove "AYN" from email to respond
"x15" <[email protected]> wrote in message
news:[email protected]...
>
> x15 Wrote:
>> Hi guys,
>> How to delete empty rows in multiple column? Here's the example of the
>> data..
>>
>>
>> Pls see attachment for the sample. Thanks & have a nice day
>
>
> --
> x15
> ------------------------------------------------------------------------
> x15's Profile:
> http://www.excelforum.com/member.php...o&userid=29510
> View this thread: http://www.excelforum.com/showthread...hreadid=492120
>