I'm not sure if this would be a macro script because it involves moving values and autopopulating... Here's a scenario

IF Col 6 'contains a P' move entire value of field (i.e. 1234P) to Column 77, AND populate Column 108 with the letter P