Hello, I have a .CSV file which contains comments, my problem is that a single comment is separated into several lines with a random number of empty cells between (no more than 20). What I would like to do is append each block of comments into a single line. What I have done so far is replace all empty cells with "null" so that they can be skipped based on containing "null" (no desirable text contains the word null). I am a total python noob and have been trying to do this in excel, but I have a friend who is experienced with python willing to help me run the code if I can figure out what needs to be done. Your help is much appreciated.
An example of what I have is:
What I need to have is
Comment 2(a) comment 2(b) comment 2(c)