Need To Add Same Text In Every nth Row (Column A) and Pull Other Cell Data Into Same Row B

Hello,

Is it possible to make every 17th row column A state the same thing without manually inputting it and then would is it possible to get every 17th row column B to pull certain data from other cells in B and put it together?

Example Column A has First Name, Last Name, and Phone. Column B will have the manual inputs.
Then I add another blank row after Phone for Password. The password will be the last name and last two digits of the phone. Is it possible to do this automatically if the other three fields are filled or does it also have to be manually input?

Any pointer is helpful. Thank you for your time in reading this.

Does this help?

Please Login or Register  to view this content.

The other fields are not needed. Just had to be on the document .Before.pngAfter.png

Also, thank you JOHN H. DAVIS and JasperD for answering. I tried your lines JasperD and it came up as error 16, too complex. I broke it into two parts but was only able to get the 17th lines to state the same thing. As for pulling the other info, its still too complex. The one that JOHN H. DAVIS posted pulls line 3 from column B for that column.

I tried your lines JasperD and it came up as error 16, too complex. I broke it into two parts but was only able to get the 17th lines to state the same thing. As for pulling the other info, its still too complex. Thank you for the info though. I replied on the post and then realized today there is a "Reply" button.