There are data in other columns. I can not delete entire rows.

Because there are data in other columns. I can not delete entire rows. I tried deleting cells but cannot.
Your methond is really good except my spread has the special consideration. Thanks a lot for help.

所有跟帖： 

• Try this, it should work. -jjbear- ♂ (405 bytes) () 07/22/2010 postreply 09:10:26

• Yep, this is a smart way to just work on the two columns. Thanks -wxcqt- ♂ (0 bytes) () 07/22/2010 postreply 12:09:43

• Excellent. Can u help me to arrage the data from a column to a r -xyz100- ♂ (0 bytes) () 07/22/2010 postreply 12:33:47

• 回複：Excellent. Can u help me to arrage the data from a column to -xyz100- ♂ (68 bytes) () 07/22/2010 postreply 12:35:17

• Use transpose -jjbear- ♂ (116 bytes) () 07/22/2010 postreply 15:13:35

• 瓦，這幕簡單呀? 謝謝，還真管用， -xyz100- ♂ (0 bytes) () 07/22/2010 postreply 18:03:37