Spreadsheet: 790168d1659560154-help-rearranging-data-into-rows-from-2-columns-new-email-format
Sheet: Example 3 Person

Passenger Name: Person A
Access Consideration(s): uses a walking stick, Other mobility aid user
[NAME]
Pax Leg Origin: [NAME] (Lancs) | DEP Time: 03/08 08:47
Pax Leg Destination: [NAME] | ARR Time: 03/08 09:24
Headcode at Destination: 1M91 | [NAME]: T
Coach: | Seat:
Station Assistance: Please assist customer onto the train with luggage and find appropriate seating , Use of station buggy (if available), Help with luggage, Assistance for Boarding
On Train Assistance: Use of station buggy (if available), Help with luggage
Meeting Point: Information Kiosk within the Waiting Room on Platform 3
Contact Details:
Booking Ref: | Seat Reservation reference:
Journey Origin: [NAME] (Lancs) | Journey Destination: [NAME]
Passenger Name: Person B
Access Consideration(s): Visual impairment, Hard of hearing/ Deaf, Accompanied by Guide Dog
Arrive
Pax Leg Origin: [NAME] | DEP Time: 03/08 09:01
Pax Leg Destination: [NAME] (Lancs) | ARR Time: 03/08 09:33
Headcode at Destination: 2N02 | [NAME]: N
Coach: | Seat:
Station Assistance: Appreciate the priority seating to accommodate my dog. Obviously wheelchair used to take priority, Room for Assistance Dog, Request priority seat, Assistance for Alighting
On Train Assistance: Appreciate the priority seating to accommodate my dog. Obviously wheelchair used to take priority, Room for Assistance Dog, Request priority seat
Meeting Point: Off train
Contact Details:
Booking Ref: PA- | Seat Reservation reference:
Journey Origin: [NAME] | Journey Destination: [NAME] (Lancs)
Passenger Name: Person C
Access Consideration(s): daughter is a wheelchair user, Other mobility impairment, Wheelchair user (powered)(within [NAME] dimensions)
[NAME]
Pax Leg Origin: [NAME] (Lancs) | DEP Time: 03/08 09:40
Pax Leg Destination: Blackpool North | ARR Time: 03/08 10:02
Headcode at Destination: 1B17 | [NAME]:
Coach: | Seat:
Station Assistance: Arriving at station by Car, Use of ramp, Assistance for Boarding
On Train Assistance:
Meeting Point: Waiting room/information desk
Contact Details:
Booking Ref: | Seat Reservation reference:
Journey Origin: [NAME] (Lancs) | Journey Destination: Blackpool North
Passenger Name: Persob D
Access Consideration(s): guidance and luggage, Other mobility aid user
Arrive
Pax Leg Origin: [NAME] | DEP Time: 03/08 09:21
Pax Leg Destination: [NAME] (Lancs) | ARR Time: 03/08 09:43
Headcode at Destination: 1B22 | [NAME]:
Coach: | Seat:
Station Assistance: Guidance from seat. , Help with luggage, Assistance for Transferring trains, Assistance for Alighting
On Train Assistance:
Meeting Point:
Contact Details:
Booking Ref: | Seat Reservation reference:
Journey Origin: [NAME] | Journey Destination: [NAME]
Passenger Name: Person E
Access Consideration(s): Accompanied by Guide Dog, Accompanied by [NAME], Visual impairment
Arrive
Pax Leg Origin: Blackpool Pleasure Beach | DEP Time: 03/08 09:15
Pax Leg Destination: [NAME] (Lancs) | ARR Time: 03/08 09:50
Headcode at Destination: 2S54 | [NAME]
Coach: | Seat:
Station Assistance: Blind with white stick. I require assistance in the station to train. Onto the train to the seat. From seat off the train. Through the station., Departing at station by Train/metro/tube, Seat transfer, Assistance for Alighting
On Train Assistance: Blind with white stick. I require assistance in the station to train. Onto the train to the seat. From seat off the train. Through the station., [NAME] by traincrew for disembarking, [NAME] by traincrew for boarding, Seat transfer
Meeting Point:
Contact Details:
Booking Ref: PA | Seat Reservation reference:
Journey Origin: Blackpool Pleasure Beach | Journey Destination: [NAME] (Lancs)
Passenger Name: Person F
Access Consideration(s): guidance and luggage, Other mobility aid user
[NAME]
Pax Leg Origin: [NAME] (Lancs) | DEP Time: 03/08 09:52
Pax Leg Destination: [NAME] | ARR Time: 03/08 12:18
Headcode at Destination: 9S44 | [NAME]
Coach: | Seat:
Station Assistance: Guidance to seat. Call ahead to confirm PAX location. , Help with luggage, Assistance for Boarding
On Train Assistance:
Meeting Point:
Contact Details: 01
Booking Ref: | Seat Reservation reference:
Journey Origin: [NAME] | Journey Destination: [NAME]
Passenger Name: Person G
Access Consideration(s): Crutches., Other mobility impairment, Other mobility aid user
[NAME]
Pax Leg Origin: [NAME] (Lancs) | DEP Time: 03/08 10:00
Pax Leg Destination: [NAME] | ARR Time: 03/08 12:10
Headcode at Destination: 1M08 | [NAME]:
Coach: | Seat:
Station Assistance:
On Train Assistance:
Meeting Point:
Contact Details:
Booking Ref: PA- | Seat Reservation reference:
Journey Origin: [NAME] (Lancs) | Journey Destination: [NAME]