9 Replies Latest reply: Mar 6, 2018 9:09 AM by youssef belloum RSS

    transpose a table, rows and columns.

    Chiara Pannese

      Hello,

      i'd like to transpose the structure of an excel table.

      My table has this aspect:

      DATEJEN
      FEBMARAPRMAYJUNJULAUGSEP
      #MEASURE1
      #MEASURE2
      #MEASURE3
      #MEASURE4
      #MEASURE5
      #MEASURE6

       

      and i'm trying to realize somthing like this

      DATE#MEASURE1#MEASURE2#MEASURE3#MEASURE4#MEASURE5#MEASURE6
      JAN
      FEB
      MAR
      APR
      MAY
      JUN
      JUL
      AUG

      SEP

       

      Now, i tought to use crosstable  statement first and elaborate my new table starting from this discussion:

      cross table in Qlik Sense

      it seems work but not correctly because the same row is repeted many time instead of only one.

      i expect to see only one row for month.

      Have any  suggestion?

      Thanks a lot.