Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

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

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .