numbers last non blank item on a list with blanks in it

Hello,

I'm tracking data over time from different contributors. I want a footer that shows the last contribution from each contributor. Some cells will be blank in any given column and I can't use formulas in blank cells since the iPad form tool won't allow data entry on formula cells. Looks something like this:

Can this be done in Numbers?

Thanks!