Replacing newline with new rows in excel sheet

Question

I am working with an excel sheet where rows inside a particular column is written using new lines.

.

For e.g. in Fig 1. Col D and Col E have been represented using new lines. i.e. A = Very Good, Needs Improvement. What I am trying to get is this in another form as shown. Any pointers in this regard would be helpful.

Answer 1

Try esProc, split and expand multiline words in an excel cell into multiple rows as following code.

    A 
1   =file("data.xlsx").xlsimport@t() 
2   =A1.run(Grades=Grades.split("\n"),Comment=Comment.split("\n")) 
3   =A2.news(Grades.len();Names,Class,Year,Grades(#):Grades,Comment(#):Comment) 
4   =file("result.xlsx").xlsexport@t(A3)

For more explanation, see http://c.raqsoft.com/article/1609902051322

DISCLAIMER: This is about our tool esProc. It’s freemium.