How to delete empty rows in multiple column?
 

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

How to delete empty rows in multiple column?
 

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" wrote in message ...

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

How to delete empty rows in multiple column?
 

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

How to delete empty rows in multiple column?
 

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" wrote in message
...

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