How to convert list of text string to list

Question

Hello, 
 I'm using excel plugin tools and i can read excel data but i don't need null of row so i want to delete null row. I tried to loop list of text string but cannot get it. How can i convert list of text string to list. 
 here is my test rest of screen shot

here is my excel data image

Mike Schmitt · Answer

You won't be able to "delete" anything. You can clean up your results in various ways, but it depends on what you want. Do you just want all non-null values? Do you want to exclude just rows that contain all nulls (but not exclude ones that contain any data even if mixed with SOME nulls)? It's pretty unclear here what you're starting with and what you're after, so it's hard to make any definitive recommendations.

How to convert list of text string to list

Top Replies