excel - is there any formula that can be used to duplicate a particular cell specified numer of times? -


im working on data have list of company names 1 below other . eg.

 1.  2. b  3. c 

and many more...
result needed

 1.  2.  3.  4.  5.  6. b  7. b  8. b  9. b  10. b  11. c  12. c  13. c  14. c  15. c 

and on...
data huge task manually.therefore great if can suggest formula can simplify work :)

with data in column a, in b1 enter:

=index(a:a,roundup(rows($1:1)/5,0)) 

and copy down:

enter image description here

to 6 repeats, use 6 in place of 5


Comments

Popular posts from this blog

get url and add instance to a model with prefilled foreign key :django admin -

css - Make div keyboard-scrollable in jQuery Mobile? -

ruby on rails - Seeing duplicate requests handled with Unicorn -