12 Replies Latest reply: Nov 8, 2013 1:27 AM by Tresesco B RSS

    Extracting first row within the row from a column

      Hi,

       

      How to load data from a column when we have multiple rows with in a row.

      Example:

       

      Header 1
      Name
      Steven
      Joseph
      Cruz
      Alex
      Yoh
      Chang
      Yan
      Screw
      Saw

       

      Output should be:

       

      Header 1
      Name
      Steven
      Alex
      Screw

       

      Please help me on this example.