Append Changes to Existing Text in SharePoint List Columns 

Yes, it is possible. You will need to create a content type, add a multiline text field and enable the allow unlimited length in document libraries setting.

Yes, there are several ways of splitting a column in two. For example it can be done with Access and a workflow. The requirement is of course that the names have been entered in a consistent way which is not always the case.

Thank you, that is a great compliment for me. I am glad to hear that you found this demo helpful.

You can do a workflow that reads the latest value into another column which does not have the Append Changes setting.

Thanks a lot!