文交所网站开发,wordpress页面编辑插件,怎么建网站挣钱,所见即所得的网站开发软件Excel由多个纵向的分组表组成#xff0c;组之间由空白行隔开#xff0c;每组第1、2行的第2格是分组表头#xff0c;第3行是列头#xff0c;第1列和第6列数据是空白的#xff1a;
ABCDEF1ATLANTIC SPIRIT2Looe3VesselSpeciesSizeKgDateLocation4POLLACK22.523/04/20245POL…Excel由多个纵向的分组表组成组之间由空白行隔开每组第1、2行的第2格是分组表头第3行是列头第1列和第6列数据是空白的
ABCDEF1ATLANTIC SPIRIT2Looe3VesselSpeciesSizeKgDateLocation4POLLACK22.523/04/20245POLLACK318.823/04/20246POLLACK415.423/04/20247LING31.923/04/20248WHITING20.423/04/2024910BEADY EYE11Plymouth12VesselSpeciesSizeKgDateLocation13BASS415.723/04/202414BASS53.223/04/20241516BOY JACK17Plymouth18VesselSpeciesSizeKgDateLocation19PLAICE10.823/04/202420BLONDE RAY114.323/04/202421BLONDE RAY31.623/04/202422SPOTTED RAY51.223/04/202423THORNBACK RAY16.323/04/202424THORNBACK RAY215.723/04/202425THORNBACK RAY310.923/04/202426THORNBACK RAY42.623/04/202427LOBSTER12.723/04/202428LOBSTER21.123/04/202429RAY BACKS142.123/04/2024
需要把每组第1、2行的分组表头填入第1列和第6列
ABCDEF1ATLANTIC SPIRIT2Looe3VesselSpeciesSizeKgDateLocation4ATLANTIC SPIRITPOLLACK22.523/04/2024Looe5ATLANTIC SPIRITPOLLACK318.823/04/2024Looe6ATLANTIC SPIRITPOLLACK415.423/04/2024Looe7ATLANTIC SPIRITLING31.923/04/2024Looe8ATLANTIC SPIRITWHITING20.423/04/2024Looe910BEADY EYE11Plymouth12VesselSpeciesSizeKgDateLocation13BEADY EYEBASS415.723/04/2024Plymouth14BEADY EYEBASS53.223/04/2024Plymouth1516BOY JACK17Plymouth18VesselSpeciesSizeKgDateLocation19BOY JACKPLAICE10.823/04/2024Plymouth20BOY JACKBLONDE RAY114.323/04/2024Plymouth21BOY JACKBLONDE RAY31.623/04/2024Plymouth22BOY JACKSPOTTED RAY51.223/04/2024Plymouth23BOY JACKTHORNBACK RAY16.323/04/2024Plymouth24BOY JACKTHORNBACK RAY215.723/04/2024Plymouth25BOY JACKTHORNBACK RAY310.923/04/2024Plymouth26BOY JACKTHORNBACK RAY42.623/04/2024Plymouth27BOY JACKLOBSTER12.723/04/2024Plymouth28BOY JACKLOBSTER21.123/04/2024Plymouth29BOY JACKRAY BACKS142.123/04/2024Plymouth 使用 SPL XLL输入公式
spl(t?.groupi(!~.ifn()),k1,t.run(t1~(k)(2),t6~(k1)(2),~.m(k3:).run(~(1)t1,~(6)t6),k2),t.conj(),A1:F29)函数 groupi 按条件进行分组ifn()返回第 1 个非空成员~ 是当前成员~(6) 是当前成员的第 6 个下级成员m(k1:) 是第 k1 个到最后一个成员。
