Spreadsheet: 814717d1674562565-create-multiple-columns-from-one-column-selecting-only-certain-rows-sample-workbook_230124
Sheet: Sample Sheet

 | RosterAreaOpShopSorted Table |  |  |  |  |  | Sample Output with no selection from Area as needed
 | Surname | Area | Display Name | Days Worked
 | Surname 1 | A | (a) Anne  P | 1,2,5 |  |  |  | (o) Irene  C |  | (os) [NAME]  R |  | (o) Carmel   P |  | (o) [NAME] |  | (r) [NAME]
 | Surname 2 | A | (a) Beate  H | 4 |  | 2023-01-23 00:00:00 | (a) [NAME]   H | (o) Marion   P | (d) Paul  H | (os) [NAME]   B | (a) Jan   D | (o) Glenis   C | (a) [NAME]   H | (o) Pauline  P | (d) [NAME] | (r) [NAME]
 | Surname 3 | A | (a) [NAME]  S | 3 |  |  | (d) [NAME] | (o) Nola  S | (d) [NAME] | (os) [NAME] | (a) Jan   M | (o) [NAME] | (a) Jan   D | (o) [NAME]   B | (d) [NAME]  A | (s) [NAME]
 | Surname 4 | A | (a) [NAME]   H | 1,4 |  |  | (d) [NAME]   K | (os) [NAME] | (h) [NAME] | (r) [NAME]   B | (a) Sue  R | (o) Lyn  B | (a) Jan   M | (os) [NAME]  B | (h) Benjanin  W | (s) Clare  H
 | Surname 5 | A | (a) Jan   D | 3,4 |  |  | (h) Benjanin  W | (r) Ann   L | (h) [NAME] | (r) [NAME]   I | (d) [NAME]  H | (os) [NAME]  B | (a) Sue  R | (os) Laurell   C | (h) [NAME] | (s) [NAME]   G
 | Surname 6 | A | (a) Jan   M | 3,4 |  |  | (h) [NAME]   K | (r) [NAME] | (h) [NAME] | (s) [NAME]   G | (h) Caroline   E | (os) [NAME] | (d) [NAME] | (s) [NAME]  L | (h) [NAME] | (s) [NAME]   H
 | Surname 7 | A | (a) Sue  R | 3,4 |  |  | (h) Gwen   G | (r) [NAME]   P | (h) [NAME]  B | (s) [NAME] | (h) [NAME] | (r) [NAME] | (h) Graeme  H | (s) [NAME]   H | (h) [NAME]  B
 | Surname 8 | D | (d) [NAME] | 5 |  |  | (h) [NAME] | (s) Bev   W | (h) [NAME] | (s) Maree   S | (h) [NAME] | (s) Christine  H | (h) [NAME] | (s) [NAME] | (h) [NAME]  T
 | Surname 9 | D | (d) [NAME]   A | 6 |  |  | (h) [NAME] | (s) Christine  H | (k) [NAME] | (s) Maureen  G | (h) [NAME] | (s) Clare  H | (h) [NAME] |  | (k) [NAME]
 | Surname 10 | D | (d) [NAME]  H | 3 |  |  | (h) [NAME]  B | (s) Clare  H | (k) [NAME] |  | (h) [NAME]  T | (s) [NAME]  L | (h) [NAME] |  | (k) [NAME]  O
 | Surname 11 | D | (d) [NAME] | 4 |  |  | (h) [NAME]  T | (s) [NAME] | (k) [NAME]   M |  | (h) Russell   M |  | (k) [NAME] |  | (o) [NAME]  R
 | Surname 12 | D | (d) Paul  H | 2 |  |  | (k) Dawn   H |  | (o) [NAME] |  | (h) [NAME]  H |  | (k) Lyn   H |  | (o) [NAME]
 | Surname 13 | D | (d) [NAME] | 1 |  |  | (k) [NAME]  O |  | (o) [NAME] |  | (k) [NAME]  O |  | (k) [NAME]  C |  | (o) Marion   P
 | Surname 14 | D | (d) [NAME]  A | 5 |  |  | (k) [NAME] |  | (o) [NAME] |  | (k) Nola  O |  | (o) [NAME] |  | (o) [NAME]   B
 | Surname 15 | D | (d) [NAME] | 2 |  |  | (o) [NAME] |  | (os) [NAME] |  | (k) Thelma  Y |  | (o) Glenis   C |  | (os) [NAME]
 | Surname 16 | D | (d) [NAME]   K | 1
 | Surname 17 | H | (h) Benjanin  W | 1,5
 | Surname 18 | H | (h) Caroline   E | 3 |  |  |  | (o) Irene  C |  | (os) [NAME]  R |  | (o) Carmel   P |  | (o) [NAME] |  | (r) [NAME]
 | Surname 19 | H | (h) [NAME] | 3 |  |  | (a) [NAME]   H | (o) Marion   P | (d) Paul  H | (os) [NAME]   B | (a) Jan   D | (o) Glenis   C | (a) [NAME]   H | (o) Pauline  P | (d) [NAME] | (r) [NAME]
 | Surname 20 | H | (h) [NAME]   K | 1 |  |  | (d) [NAME] | (o) Nola  S | (d) [NAME] | (os) [NAME] | (a) Jan   M | (o) [NAME] | (a) Jan   D | (o) [NAME]   B | (d) [NAME]  A | (s) [NAME]
 | Surname 21 | H | (h) [NAME] | 2,5 |  |  | (d) [NAME]   K | (os) [NAME] | (h) [NAME] | (r) [NAME]   B | (a) Sue  R | (o) Lyn  B | (a) Jan   M | (os) [NAME]  B | (h) Benjanin  W | (s) Clare  H
 | Surname 22 | H | (h) Graeme  H | 4 |  |  | (h) Benjanin  W | (r) Ann   L | (h) [NAME] | (r) [NAME]   I | (d) [NAME]  H | (os) [NAME]  B | (a) Sue  R | (os) Laurell   C | (h) [NAME] | (s) [NAME]   G
 | Surname 23 | H | (h) Gwen   G | 1 |  |  | (h) [NAME]   K | (r) [NAME] | (h) [NAME] | (s) [NAME]   G | (h) Caroline   E | (os) [NAME] | (d) [NAME] | (s) [NAME]  L | (h) [NAME] | (s) [NAME]   H
 | Surname 24 | H | (h) [NAME] | 3,4,5 |  |  | (h) Gwen   G | (r) [NAME]   P | (h) [NAME]  B | (s) [NAME] | (h) [NAME] | (r) [NAME] | (h) Graeme  H | (s) [NAME]   H | (h) [NAME]  B
 | Surname 25 | H | (h) [NAME] | 4 |  |  | (h) [NAME] | (s) Bev   W | (h) [NAME] | (s) Maree   S | (h) [NAME] | (s) Christine  H | (h) [NAME] | (s) [NAME] | (h) [NAME]  T
 | Surname 26 | H | (h) [NAME] | 4 |  |  | (h) [NAME] | (s) Christine  H | (k) [NAME] | (s) Maureen  G | (h) [NAME] | (s) Clare  H | (h) [NAME] |  | (k) [NAME]
 | Surname 27 | H | (h) [NAME] | 2 |  |  | (h) [NAME]  B | (s) Clare  H | (k) [NAME] |  | (h) [NAME]  T | (s) [NAME]  L | (h) [NAME] |  | (k) [NAME]  O
 | Surname 28 | H | (h) [NAME] | 1 |  |  | (h) [NAME]  T | (s) [NAME] | (k) [NAME]   M |  | (h) Russell   M |  | (k) [NAME] |  | (o) [NAME]  R
 | Surname 29 | H | (h) [NAME] | 1 |  |  | (k) Dawn   H |  | (o) [NAME] |  | (h) [NAME]  H |  | (k) Lyn   H |  | (o) [NAME]
 | Surname 30 | H | (h) [NAME] | 2 |  |  | (k) [NAME]  O |  | (o) [NAME] |  | (k) [NAME]  O |  | (k) [NAME]  C |  | (o) Marion   P
 | Surname 31 | H | (h) [NAME]  B | 1,2,5 |  |  | (k) [NAME] |  | (o) [NAME] |  | (k) Nola  O |  | (o) [NAME] |  | (o) [NAME]   B
 | Surname 32 | H | (h) [NAME] | 3 |  |  | (o) [NAME] |  | (os) [NAME] |  | (k) Thelma  Y |  | (o) Glenis   C |  | (os) [NAME]
 | Surname 33 | H | (h) [NAME]  T | 1,3,5
 | Surname 34 | H | (h) [NAME] | 2
 | Surname 35 | H | (h) Russell   M | 3
 | Surname 36 | H | (h) [NAME]  H | 3
 | Surname 37 | K | (k) [NAME] | 2,4,5
 | Surname 38 | K | (k) Dawn   H | 1
 | Surname 39 | K | (k) [NAME]  O | 1,3,5
 | Surname 40 | K | (k) [NAME] | 2
 | Surname 41 | K | (k) Lyn   H | 4
 | Surname 42 | K | (k) Nola  O | 3
 | Surname 43 | K | (k) [NAME]  C | 4
 | Surname 44 | K | (k) [NAME]   M | 2
 | Surname 45 | K | (k) [NAME] | 1
 | Surname 46 | K | (k) Thelma  Y | 3
 | Surname 47 | O | (o) [NAME] | 4
 | Surname 48 | O | (o) Carmel   P | 3
 | Surname 49 | O | (o) [NAME] | 2
 | Surname 50 | O | (o) [NAME] | 1
 | Surname 51 | O | (o) Glenis   C | 3,4
 | Surname 52 | O | (o) [NAME] | 2
 | Surname 53 | O | (o) [NAME]  R | 5
 | Surname 54 | O | (o) Irene  C | 1
 | Surname 55 | O | (o) [NAME] | 4,5
 | Surname 56 | O | (o) [NAME] | 3
 | Surname 57 | O | (o) Lyn  B | 3
 | Surname 58 | O | (o) Marion   P | 1,5
 | Surname 59 | O | (o) Nola  S | 1
 | Surname 60 | O | (o) Pauline  P | 4
 | Surname 61 | O | (o) [NAME]   B | 4,5
 | Surname 62 | O | (o) [NAME] | 2
 | Surname 63 | OS | (os) [NAME] | 2
 | Surname 64 | OS | (os) [NAME]  B | 3,4
 | Surname 65 | OS | (os) [NAME]  R | 2
 | Surname 66 | OS | (os) Laurell   C | 4
 | Surname 67 | OS | (os) [NAME]   B | 2
 | Surname 68 | OS | (os) [NAME] | 2,3
 | Surname 69 | OS | (os) [NAME] | 1,5
 | Surname 70 | R | (r) Ann   L | 1
 | Surname 71 | R | (r) [NAME]   B | 2
 | Surname 72 | R | (r) [NAME] | 5
 | Surname 73 | R | (r) [NAME]   I | 2
 | Surname 74 | R | (r) [NAME] | 1,3
 | Surname 75 | R | (r) [NAME]   P | 1
 | Surname 76 | R | (r) [NAME] | 5
 | Surname 77 | S | (s) [NAME] | 5
 | Surname 78 | S | (s) Bev   W | 1
 | Surname 79 | S | (s) Christine  H | 1,3
 | Surname 80 | S | (s) Clare  H | 1,3,5
 | Surname 81 | S | (s) [NAME]   G | 2,5
 | Surname 82 | S | (s) [NAME]  L | 3,4
 | Surname 83 | S | (s) [NAME]   H | 4,5
 | Surname 84 | S | (s) [NAME] | 1,2
 | Surname 85 | S | (s) [NAME] | 4
 | Surname 86 | S | (s) Maree   S | 2
 | Surname 87 | S | (s) Maureen  G | 2