CODEWITHSUNDEEP
excelcells
Glowie
Glowie

Reputation: 2309

Copy EXCEL cell x number of times

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?

Upvotes: 5

Views: 23600

Answers (1)

Jerry
Jerry

Reputation: 71538

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.

Upvotes: 14

Related Questions