Spreadsheet: 218197d1362395981-if-same-column-in-multiple-sheets-is-marked-with-an-x-how-can-i-extract-surrounding-data-upload-data
Sheet: Week 3

 |  |  |  |  | Climbers | Small evergreen | [NAME] | Fuchsia | Fruit | Hanging Basket | [NAME] | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  | Bridgewater | Thrapston | Bradford | Gadbrook | [NAME] | [NAME] | Motherwell
 |  |  |  | No. In Box | 18 | 12 | 6 | 18 | 12 | 4 | 4 | 216 | 162 |  |  |  |  |  |  |  |  |  | Cost of Transport | 10 | 10 | 10 | 10 | 10 | 10 | 10
 |  |  |  | No. On [NAME] | 40 | 50 | 50 | 40 | 50 | 30 | 40 | 2.5 | 2.5 |  |  |  |  |  |  |  |  |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  | Space on [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Cost
 | Sunday
 | Depot | Order No. | Date | Date Code | Climbers | Small evergreen | [NAME] | Fuchsia | Fruit | Hanging Basket | [NAME] | [NAME] | [NAME] | Total Boxes | Total Stands | Stand Pallets | Boxed Pallets | Total Pallets | Opperman | WARNING |  |  | Transport Cost | Climbers | Small evergreen | [NAME] | Fuchsia | Fruit | Hanging Basket | [NAME] | [NAME] | [NAME] | Total Cost | [NAME]
 | Bridgewater | a | 2013-02-24 00:00:00 | 3--1 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 0 | 0 |  |  |  |  |  | x |  |  | Click for Transport Sheet
 | Thrapston | b | 2013-02-24 00:00:00 |  | 5 |  | 5 | 5 |  |  |  |  |  |  |  |  |  |  | x
 | Bradford | c | 2013-02-24 00:00:00 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | Gadbrook | d | 2013-02-24 00:00:00 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | [NAME] | e | 2013-02-24 00:00:00 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | Click for Despatch Sheet
 | [NAME] | f | 2013-02-24 00:00:00 |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | Total Boxes
 | Motherwell | g |  | 3--2 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | Total Boxes
 | Monday
 | Depot | Order No. | Date | Date Code | Climbers | Small evergreen | [NAME] | Fuchsia | Fruit | Hanging Basket | [NAME] | [NAME] | [NAME] | Total Boxes | Total Stands | Stand Pallets | Boxed Pallets | Total Pallets |  | WARNING |  |  | Transport Cost | Climbers | Small evergreen | [NAME] | Fuchsia | Fruit | Hanging Basket | [NAME] | [NAME] | [NAME] | Total Cost | [NAME]
 | Bridgewater | h |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | Click for Transport Sheet
 | Thrapston | i |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | Bradford | j |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | Gadbrook | 54868 |  |  | 5 | 5 | 5 |  |  |  |  |  |  |  |  |  |  |  | x
 | [NAME] | l |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | Click for Despatch Sheet
 | [NAME] | m |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | Total Boxes
 | Motherwell | n |  | 3--3 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | Total Boxes
 | Tuesday
 | Depot | Order No. | Date | Date Code | Climbers | Small evergreen | [NAME] | Fuchsia | Fruit | Hanging Basket | [NAME] | [NAME] | [NAME] | Total Boxes | Total Stands | Stand Pallets | Boxed Pallets | Total Pallets |  | WARNING |  |  | Transport Cost | Climbers | Small evergreen | [NAME] | Fuchsia | Fruit | Hanging Basket | [NAME] | [NAME] | [NAME] | Total Cost | [NAME]
 | Bridgewater | q |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | Click for Transport Sheet
 | Thrapston | w |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | Bradford | e |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | Gadbrook | r |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | [NAME] | t |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | Click for Despatch Sheet
 | [NAME] | y |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | Total Boxes
 | Motherwell | . |  | 3--4 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | Total Boxes
 | Wed
 | Depot | Order No. | Date | Date Code | Climbers | Small evergreen | [NAME] | Fuchsia | Fruit | Hanging Basket | [NAME] | [NAME] | [NAME] | Total Boxes | Total Stands | Stand Pallets | Boxed Pallets | Total Pallets |  | WARNING |  |  | Transport Cost | Climbers | Small evergreen | [NAME] | Fuchsia | Fruit | Hanging Basket | [NAME] | [NAME] | [NAME] | Total Cost | [NAME]
 | Bridgewater | q |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | Click for Transport Sheet
 | Thrapston | w |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | Bradford | e |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | Gadbrook | r |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | [NAME] | t |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | Click for Despatch Sheet
 | [NAME] | y |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | Total Boxes
 | Motherwell | . |  | 3--5 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | Total Boxes
 | Thurs
 | Depot | Order No. | Date | Date Code | Climbers | Small evergreen | [NAME] | Fuchsia | Fruit | Hanging Basket | [NAME] | [NAME] | [NAME] | Total Boxes | Total Stands | Stand Pallets | Boxed Pallets | Total Pallets |  | WARNING |  |  | Transport Cost | Climbers | Small evergreen | [NAME] | Fuchsia | Fruit | Hanging Basket | [NAME] | [NAME] | [NAME] | Total Cost | [NAME]
 | Bridgewater | q |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | Click for Transport Sheet
 | Thrapston | w |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | Bradford | e |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | Gadbrook | r |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | [NAME] | t |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | Click for Despatch Sheet
 | [NAME] | y |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | Total Boxes
 | Motherwell | . |  | 3--6 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | Total Boxes
 | Friday
 | Depot | Order No. | Date | Date Code | Climbers | Small evergreen | [NAME] | Fuchsia | Fruit | Hanging Basket | [NAME] | [NAME] | [NAME] | Total Boxes | Total Stands | Stand Pallets | Boxed Pallets | Total Pallets |  | WARNING |  |  | Transport Cost | Climbers | Small evergreen | [NAME] | Fuchsia | Fruit | Hanging Basket | [NAME] | [NAME] | [NAME] | Total Cost | [NAME]
 | Bridgewater | q |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | Click for Transport Sheet
 | Thrapston | w |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | Bradford | e |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | Gadbrook | r |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | [NAME] | t |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | Click for Despatch Sheet
 | [NAME] | y |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | Total Boxes
 | Motherwell | . |  | 3--7 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | Total Boxes
 | Sat
 | Depot | Order No. | Date | Date Code | Climbers | Small evergreen | [NAME] | Fuchsia | Fruit | Hanging Basket | [NAME] | [NAME] | [NAME] | Total Boxes | Total Stands | Stand Pallets | Boxed Pallets | Total Pallets |  | WARNING |  |  | Transport Cost | Climbers | Small evergreen | [NAME] | Fuchsia | Fruit | Hanging Basket | [NAME] | [NAME] | [NAME] | Total Cost | [NAME]
 | Bridgewater | q |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | Click for Transport Sheet
 | Thrapston | w |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | Bradford | e |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | Gadbrook | r |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | [NAME] | t |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x |  |  | Click for Despatch Sheet
 | [NAME] | y |  |  | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | Total Boxes
 | Motherwell | . |  | 4--1 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  | x
 | Total Boxes