2 Replies Latest reply on Aug 24, 2016 12:20 PM by Dim Pl

    Merging information from 2 or more columns.

    Dim Pl

      Hello

       

      I am trying to analyse a set of data of the following form:

       

           

      serialforetag1branch1foretag2branch2foretag3branch3foretag4branch4foretag5branch5
      1sfbiovoltkladderiksugymgregerskladderespressohousekaffe
      2invitonojerexnojetajmahalrestaurantkoksbarenpubolearysnoje
      3namatbutiknakaffenarestaurantnaovrigtnagym
      4systembolagetalcoholicamatbutikikeamoblerolearysnojeadidassportkladder
      5willysmatbutikicamatbutikh&mkladdersephoracosmeticsahlenskladder
      6sfbiomaxrestaurantteamsportiasportkladderstadiumsportkladderkickscosmetics
      7viaplaynojenanah&mkladderzarakladderralphlaurenkladder
      8narestauranth&mkladdernadancenakollektivtrafiknaresor
      9maxrestaurantlykocosmeticsh&mkladdersfbioespressohousekaffe
      10vezzoresturantiksugympeakperformancesportkladderscorettscorattitydfrisor

       

       

       

      Although its fairly easy to graph how many times one observation appears in a single column (ie branch3) it is not straightforward how to graph observations of a combination of columns in a single graph (ie branch3 and branch2 and branch1).

      Please check the workbook.

       

      Thanks in advance.