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

請您先登陸,再發跟帖!