Forum Discussion
Anonymous
4 years agoNot applicable
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.
- Anonymous4 years ago
Below split operation worked to split above data into separate rows.
FInal Output:
3 Replies
- AnonymousNot applicable
Below split operation worked to split above data into separate rows.
FInal Output:
- y-dubourgFrequent Visitor
Do you have line breaks in column Item Sent?
- AnonymousNot 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.