2 Replies Latest reply: May 5, 2016 11:13 AM by Sujana R RSS

    Duplicate the data for the same respondent

    Sujana R

      Hi,

       

      I have a data which shows as below:

       

         

      IDNameCase
      123Mike
      123 3
      123
      345Robert
      345 6
      345
      567James4
      567
      1234Jim
      1234 5
      1234

       

      Result i am looking for is:

       

         

      IDNameCase
      123Mike3
      123Mike3
      123Mike3
      345Robert6
      345Robert6
      345Robert6
      567James4
      567James4
      1234Jim5
      1234Jim5
      1234Jim5

       

      I want data values to be repeated. Could someone please help me in how to do in the script and in the Table.

       

      Thanks