Hi there @brianpadua,
welcome to KNIME Community!
I have played a bit with it and came up with following workflow which should cover #1. Check it out and ask if any questions. It is partly documented and hopefully you will figure out where to place logic for other columns 
Sample.knwf 1.knwf (47.3 KB)
Br,
Ivan