Adding new column based on another column criteria on the same table

Hello, I have this problem where I wanted to add a new column based on the criteria from another column on the same table.  Below is what my table looks like.  Number Link Type Party ID 5...