關鍵字重覆保留第一組,其餘刪除後,退回上一行?
如題,怎麼從1到3?
1、
aaa comment "項目1"
aaa add "100"
aaa add "200"
aaa add "300"
bbb comment "項目2"
bbb add "400"
bbb add "500"
bbb add "600"
bbb add "700"
bbb add "800"
2、
aaa comment "項目1"
"100"
"200"
"300"
bbb comment "項目2"
"400"
"500"
"600"
"700"
"800"
3、
aaa comment "項目1""100" "200" "300"
bbb comment "項目2" "400" "500" "600" "700" "800"
現在是用excel慢慢行轉列再刪除空白行。
另外再請教怎麼符合關鍵字那一行就全刪除? 謝謝。
如:只要有aaa就整行刪除
aaa comment "項目1""100" "200" "300"
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 114.36.121.172
※ 文章網址: http://www.ptt.cc/bbs/Editor/M.1397744732.A.FD3.html
→
04/17 23:06, , 1F
04/17 23:06, 1F
→
04/17 23:06, , 2F
04/17 23:06, 2F
→
04/17 23:20, , 3F
04/17 23:20, 3F
→
04/17 23:22, , 4F
04/17 23:22, 4F
→
04/17 23:23, , 5F
04/17 23:23, 5F
推
04/18 09:46, , 6F
04/18 09:46, 6F
推
04/18 12:46, , 7F
04/18 12:46, 7F
推
04/19 20:22, , 8F
04/19 20:22, 8F
→
04/19 20:23, , 9F
04/19 20:23, 9F
→
04/19 20:24, , 10F
04/19 20:24, 10F
推
04/19 20:28, , 11F
04/19 20:28, 11F
→
04/19 20:36, , 12F
04/19 20:36, 12F
→
04/20 00:29, , 13F
04/20 00:29, 13F
推
08/24 17:51, , 14F
08/24 17:51, 14F
討論串 (同標題文章)
以下文章回應了本文 (最舊先):
完整討論串 (本文為第 1 之 6 篇):