spreadsheet

Problem description & analysis The Excel worksheet below contains multiple vertical subtable groups, which are separated by a blank row. In each group, the 2nd cells of both row 1 and row 2 contain subtable group headers and row 3 contains column headers; there isn’t detailed data in either the 1st column or the 6th column: A B C D E F 1 ATLANTIC SPIRIT 2 Looe 3 Vessel Species Size Kg Date Location 4 POLLACK 2 2.5 23/04/2024 5 POLLACK 3 18.8 23/04/2024 6 POLLACK 41 5.4 23/04/2024 7 LING 3 1.9 23/04/2024 8 WHITING 2 0.4 23/04/2024 9…