Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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

1 Answer 1

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.