Hello 
and welcome to the forum, @zl3dred
I think that the community could best help you if you shared a screenshot of your data in table format, and maybe your raw unformatted data as well.
That way we could try and mock up your issue.
in the meantime:
for 1: try using the stat panel and selecting last from the panel editor
for 2: try using regex-based value mapping
