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

回答: 一个Excel问题,可否拖拽产生数据wxcqt2010-07-21 07:25:40

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- 给 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- 给 wxcqt 发送悄悄话 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- 给 xyz100 发送悄悄话 xyz100 的博客首页 (0 bytes) () 07/22/2010 postreply 12:33:47

回复:Excellent. Can u help me to arrage the data from a column to -xyz100- 给 xyz100 发送悄悄话 xyz100 的博客首页 (68 bytes) () 07/22/2010 postreply 12:35:17

Use transpose -jjbear- 给 jjbear 发送悄悄话 (116 bytes) () 07/22/2010 postreply 15:13:35

瓦,这幕简单呀? 谢谢,还真管用, -xyz100- 给 xyz100 发送悄悄话 xyz100 的博客首页 (0 bytes) () 07/22/2010 postreply 18:03:37

请您先登陆,再发跟帖!