How do I add the last value of 'Append Changes to Existing Text' data to a column. i.e. Say I have a Column A with data 123 but it has changed to 456. Now, I want data 123 which is the previous value in a column. Is it possible?
An 'Append Changes to Existing Text' column is storing each of it's values in the different versions of the list item, and then just collecting all of these for display.