Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am using Microsoft Excel and I have a column with number :

1
0
6
.
.
.
0

and I'd like to duplicate 4 time each value in a new column :

1
1
1
1
0
0
0
0
6
6
6
6
.
.
.
0
0
0
0

Is there a function to do so? Thank you for your help.

share|improve this question
up vote 3 down vote accepted

Assuming that your first column is A, you can duplicate the values four times using something like the follwoing filled down column B:

=INDIRECT("A"& CEILING(ROW()/4,1))
share|improve this answer
    
Thank you for your answer. It works well. There is a little mistake, it's ;instead of ,. In my case, I am using Excel in french so the ROW()and CEILING() functions don't work. It's respectively LIGNE() and PLAFOND(). – Michaël May 13 '12 at 14:25
    
I'm glad that it worked. The comma vs semicolon separators are locale specific in addition to the function names. – Nathan Clayton Mar 25 '13 at 6:03

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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