5 Replies Latest reply: Aug 9, 2013 9:43 AM by Paul Nockolds RSS

    Transpose? Crosstable? Generic Load?

    Paul Nockolds

      QV11 SR2

       

      I'm trying to work out the best way to transpose the following data.  I've been looking at possibly using transpose, crosstable or generic load but i'm not quite which if any are the best to use.  Any advice much appreciated.

       

      Data.gif

       

      This is the format i am trying to achieve...

       

      Result.gif