Extract values from a cell into separate rows

[Anonymous]

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.

[y-dubourg]

Do you have line breaks in column Item Sent?

[Anonymous]

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.

[Anonymous · Accepted solution]

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

FInal Output: