1 Reply Latest reply on Mar 2, 2017 7:33 AM by Norbert Maijoor

    How can i merge two data sets with same columns but different rows

    César orlando Pallares Delgado

      Hi,

       

      I have two data sets. Both of them have exactly the same columns, with the same name, but they correspond to different rows. I show you:

       

      Table a. A1 Journals

       

      Country
      Subject
      Classification
      United StatesSociologyA1
      United KingdomHistoryA1
      ColombiaMedicineA1

       

      Table b. A2 Journals

       

      CountrySubjectClassification
      ArgentinaChemistryA2
      SwedenEconomicsA2

       

      What I want to do is to have just one table, as this one

       

      Country
      Subject
      Classification
      United StatesSociologyA1
      United KingdomHistoryA1
      ColombiaMedicineA1
      ArgentinaChemistryA2
      SwedenEconomicsA2

       

      How can I do this? I got bot files in Excel 2016

       

      Thanks a lot.