I have an excel with 1000 rows. Sample below:
I need to add a column next to desc column and extract the keywords from desc column.
For suppose Cat, Dog, Phone for every row in the table.
Sample output below:
Please help in solving this. Planning to use for each row activity but it will be time taking as there will be 1000 rows every time. Additionally I want to put undefined as comment for new type of data in desc column.