Forum Discussion
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 S...
Below split operation worked to split above data into separate rows.
FInal Output:
Do you have line breaks in column Item Sent?
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.