Cycle Trough Table move contents to adjacent cells

[kpasa]

For sake of example, I have a table like this:

NameCheckPoint 1CheckPoint 2CheckPoint 3Ricky   Bobby Text #2Text #1Joey Text #2Text #1Matt   Thomas Text #2Text #1

I need to cycle through each row and if there are contents in CheckPoint 2 column, run a macro I have already set up and then move the contents to Checkpoint 3, which out deleting the contents of the checkpoint 3 column. So the end result should be this:

NameCheckPoint 1CheckPoint 2CheckPoint 3Ricky   Bobby  Text #2 Text #1Joey  Text #2 Text #1Matt   Thomas  Text #2 Text #1

I know it will use the "For Each, next" syntax, but i'm not advanced enough to write it myself. I can read it, understand it, adapt it, etc. but I need help building it from scratch.

 

[kpasa]

The HTML Table didnt post so here's the post again but formatted slightly better:
For sake of example, I have a table like this:
Name, Column1, Column2
name, textnum1, textnum2


I need to cycle through each row and if there are contents in column1, run a macro I have already set up and then move the contents to Colum2, which out deleting the contents of the column1. So the end result should be this:
Name, Column1, Column2
name, , textnum1 textnum2


I know it will use the "For Each, next" syntax, but i'm not advanced enough to write it myself. I can read it, understand it, adapt it, etc. but I need help building it from scratch.