8 Replies Latest reply on Aug 21, 2018 12:02 AM by Yvonne Cheng

    Data Grouping

    Yvonne Cheng

      I have a set of data of air tickets including from city and to city. Currently Singapore(from city) to California(to city) and California(from city) to Singapore(to city) are considered 2 records.

      How to group them together? I would like to analyze air fare between 2 cities regardless of departure or arrival.

       

      Pls find attached data sample.

       

      Thanks for help in advance.

       

      Yvonne