6 Replies Latest reply: Aug 28, 2012 4:36 AM by Sander Janssen RSS

    Pivot Table

      Hi,

       

      I have a requirement which may sound simple.. but I am not able to get it right...

       

      Below in my data:

       

      idloctimecodetextnumber
      123abc2:00 PM12dfg1
      123abc11:30 PM45dxf2
      123abc4:00 AM33xcvbn3
      123abc3:30 PM67vb n4
      123abc1:00 PM98bnh5
      123abc2:45 PM24bnhghj6
      234ghy3:30 PM24hgj7
      234ghy1:00 PM33gbn8

       

      and the format in which i need it is:

       

      code1text1number1time1code2text2number2time2code3text3number3time3
      id1loc1
      id2loc2
      id3loc3

       

       

      draggin the blue line gave me 4 different rows... any ideas please..

       

      Regards...