I want to add an extra row to those records that meet certain criteria and multiply the numeric record of the added row by a certain number. Original table resembles something like this.

A B C AR 2 3 AR 4 8 FL 6 8

I would like to create a new table where a row is added for the records containing AR and for the added record; change the name AR with RA and multiply B by 2 The new table would be: A B C AR 2 3 RA 4 3 AR 4 8 RA 8 8 FL 6 8