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.