Convert multiple IF functions to a VB code on button

I am looking to turn a four stage process that I currently have in excel which see's raw data from database cleaned up and arranged accordingly to make it compatible for its next use. This has all previously been done on Excel but I am in the process of writing a small app which takes care of this a lot quicker than manual input.

So the data in question is cards face value and suit of Baccarat cards. I have attached a small sample of the Excel file the data is originally pasted into cells A2:F101 on the Raw tab, once the 'Clean Up' button is pressed the data moves cells in F left if column E is empty before is pastes it to cells A2:F101 on the Clean tab where it then goes through three simple but vital IF functions where it ends up in the desired format in cells S2:X101 on the Clean tab where the user then copies and pastes the values into another location.

My VB application is built in Visual studio 2015, the raw data is loaded from an Access database and displayed in DataGridView1, the process button needs to complete all changes then paste it to DatGridView2.

I'm relatively new on the programming side of things so my knowledge is limited, any help on this function would be greatly appreciated. VBA code I should be able to adapt and apply it to VB14 fro Visual Studio.

Thanks again guys!