13 Replies Latest reply: Feb 14, 2018 2:07 PM by Thiago Justen Teixeira RSS

    Changing rows to columns

    Stijn Valkenburg

      Hi all,

       

      I have like 20 seperate excels with below format. Is there an easy way to change the rows to columns?

        

      FieldValue
      ScoreA1
      ScoreB3
      ScoreC5

       

      So I want it in Qlik Sense like this:

       

      ScoreAScoreBScoreC
      135

       

      Thanks!