2 Replies Latest reply: Aug 23, 2012 1:16 PM by Joe Kirwan RSS

    Create new column from specific row entries in old column

    Joe Kirwan

      How can I take this data

       

      13/08/201214.15
      16/08/20128.18
      17/08/201212.22
      John Doe34.55
      14/08/20128.47
      15/08/20124.58
      16/08/20129.39
      17/08/201212.04
      18/08/201210.19
      19/08/20120.01
      AN Other45.48
      15/08/20125.3
      15/08/20129.16
      16/08/201210.08
      17/08/201211.15
      18/08/201212.15
      19/08/2012
      Mr X48.24

       

       

      and make it load like this?:

       

      John Doe13/08/201214.15
      John Doe16/08/20128.18
      John Doe17/08/201212.22
      AN Other14/08/20128.47
      AN Other15/08/20124.58
      AN Other16/08/20129.39
      AN Other17/08/201212.04
      AN Other18/08/201210.19
      AN Other19/08/20120.01
      Mr X15/08/20125.3
      Mr X15/08/20129.16
      Mr X16/08/201210.08
      Mr X17/08/201211.15
      Mr X18/08/201212.15
      Mr X19/08/2012