Menu
I have a column of about 1000 IP addresses that I need to print 5 times in a single column.
For example
10.10.10.1
10.10.10.2
10.10.10.3
10.10.10.4
should become
10.10.10.1
10.10.10.1
10.10.10.1
10.10.10.1
10.10.10.1
10.10.10.2
10.10.10.2
10.10.10.2
10.10.10.2
10.10.10.2
etc, etc
Can this be done in Excel? What functions should I research?
470
In the popping dialog, choose Copy and insert rows option in the Type section, then choose the range that you want to repeat to Insert Range textbox, and choose the column that decides the repeat times to the Repeat Times textbox. Click Ok. Then the rows will be repeated by the selected column.
Right-click the row or column label you want to repeat, and click Field Settings. Click the Layout & Print tab, and check the Repeat item labels box. Make sure Show item labels in tabular form is selected.
If your example is in range A1:A4, you can use this in column B as from cell B1:
=INDEX(A:A,INT((ROW()-1)/5)+1)
This will repeat each one 5 times.
65
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
