`id` END AS `loan_id`(SELECT `id`,`city` as `City with credit`,`fishing_segment` FROM `data` CROSS JOIN
(SELECT `id`,`city` as `City with loan`,`fishing_segment
我想根据Species合并行(如果它们是相同的鱼种),如果它们同时被Bottom fishing和Trolling方法捕获,将导致两行折叠成一行,将Method值更改为Both。NA NA 2 3 Balistidae sppBottom fishing NA NA 1
4 Caranx ignobilis Trolling NA
我有这个公式
=IFERROR(INDEX('[Fishing Contact list July 2015.xlsm]Places'!$A$2:$A$65, SMALL(INDEX(ROW($1:$64)+('[Fishing Contact list July 2015.xlsm]Places'!$Q$2:$Q$65="A"&'[Fishing Contact list July 2015.xlsm]Places'!$B$2:$B$65>=&q