An approach that should work:
-
Create an array of the elements whose last element you need. To do so, create a lookup column, select the column whose last element you need (in your case “AnsweredName”)
-
Determine the number of elements in this array. To do so, create an “Array length” column (you’ll find this column type under computed columns and array), select the column with the array of elements.
-
Determine the index of the last non-empty element. Indexes start at 0, so the index is the number of elements in the array minus 1. To do so, create a math column and subtract 1 from the number of elements.
-
Fetch the last element of the array of elements using a single value column. From the array of elements (“from” field), get the element with the last index from the start.
This image sums it up I think, this is what your columns might look like:
Another approach:
- Create the array of elements
- Reverse the array: your last element becomes the first with index 0
- Slice the array between 0 and 1 (start at 0 to include index 0, end at 1 to exclude indexes beyond 1)
- Turn the single array element returned into text (joined list column)