I currently have a spreadsheet that contains a repeating set of data in specific columns with one field in each row being blank, such as the following:

Table containing Repeating Data

I also have a column of numbers I wish to have inserted into this table. Each unique value in this column needs to go into the blank column on my table for each set of repeating numbers on my first column.

So if the first column of numbers contained 1234, 5678, 91011 one number per row, repeating down, and I have a new set of data that needs to be inserted in the next blank column with each unique new number being inserted next to a set of the repeating 3 numbers in the original column, is there a way to do this?

It would look something like the following:

Completed Table

I am repeating this by copy pasting each key into the repeating column repeatedly currently, and was looking for a way to mass enter the data. Is this possible? I would be open to doing this with code.

New contributor
Adam Hart is a new contributor to this site. Take care in asking for clarification, commenting, and answering. Check out our Code of Conduct.

Use INDEX with COUNTIF to return the correct row:


enter image description here

  • This is the ticket! Thank you! – Adam Hart Sep 11 at 17:27
  • @AdamHart if this worked for you please consider marking as correct by clicking the check mark by the answer. – Scott Craner Sep 11 at 17:28

Your Answer

Adam Hart is a new contributor. Be nice, and check out our Code of Conduct.

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.