Spreadsheet: 885141d1734556879-add-or-remove-rows-to-only-part-of-the-columns-of-a-table-add-or-embedd-a-row-into-columns-of-an-existing-table-example
Sheet: Data

A-Team
E-Team
M-Team
type selection |  |  | VLOOKUP (BookingReference) |  |  |  |  | ServiceManager tab |  |  |  | SM tab
M03 | C |  |  | X |  |  |  |  | M06 | ADV-TR1 |  |  | M06 | ADV-TR1 |  |  |  |  | BSC-TR1 | COM TR1
M04 | P |  | X | BSC |  |  |  | Bond, [NAME] | M25 | ADV-TR1 |  | C, D | M07 | ADV-TR1 |  |  |  |  | BSC-TR2 | COM TR2
M05 | F |  | BSC | BSC-SF |  |  |  | Bond, [NAME] | M16 | BSC-TR1 |  | Mouse, [NAME] | M09 | BSC-TR1 |  |  |  |  | BSC-TR3 | COM TR3
M05 IME | FI |  | BSC-IME | BSC-SF |  |  |  | C, D | M07 | ADV-TR1 |  | Bond, [NAME] | M16 | BSC-TR1 |  |  |  |  | ADV-TR1 | COM ADV1
M06 | T |  | BSC-SF | BSC-TR1 |  |  |  | C, D | M16 | ADV-TR1 |  | C, D | M16 | ADV-TR1 |  |  |  |  | ADV-TR2 | COM ADV2
M06 IME | TI |  | BSC-TR1 | BSC-TR2 |  |  |  | [NAME], [NAME] | M22 | BSC-TR1 |  | [NAME], [NAME] | M22 | BSC-TR1 |  |  |  |  | ADV-TR3 | COM ADV3
M07 | L |  | BSC-TR2 | ADV |  |  |  | Mouse, [NAME] | M09 | BSC-TR1 |  | Bond, [NAME] | M25 | ADV-TR1
M07 IME | Line Engineering |  | ADV | ADV-TR1 |  |  |  |  |  |  |  | 0 | 0 | 0
M09 | K |  | ADV-TR1 | ADV-TR2 |  |  |  |  |  |  |  | 0 | 0 | 0
M11 | LE |  | ADV-TR2 | [NAME] |  |  |  |  |  |  |  | 0 | 0 | 0
M15 | PT |  | [NAME] | Certified |  |  |  |  |  |  |  | 0 | 0 | 0
M16 | I |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
M18 | PP |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
M18 IME | PPI |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
M22 | PET |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
M22 IME | PETI |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
M25 | PK |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
M25 IME | PKI |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
M40 | AF |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
M45 | BL |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
M80 | BAR |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
M97 | FT |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
M98 | TP |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
M99 | MC |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0