Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Extract values from a cell into separate rows

Hi Guys 
i have csv file and one of the cell (Item Sent)  is having multiple values.

How we can extract Item Sent values to separate rows altogether.

 

 

Desire output:

RecordID    Item Sent

LAB12792     6

LAB12792     100

LAB12792     130

LAB12792     131

LAB12792     132

 

 

Any help is greatly appreciated.

 

  • Anonymous's avatar
    Anonymous
    4 years ago

    Below split operation worked to split above data into separate rows.

     

     

    FInal Output:

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    Below split operation worked to split above data into separate rows.

     

     

    FInal Output:

    • Anonymous's avatar
      Anonymous
      Not applicable

      the rows are having line feed.

      had to try each option one in advanced options to make it work and at last line feed did the magic.