How to duplicate 4 time values of a column?

Question

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 :

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

Nathan Clayton · Accepted Answer · 2012-05-12 18:11:21Z

3

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))

answered May 12, 2012 at 18:11

Nathan Clayton

663 bronze badges

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, 2012 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, 2013 at 6:03

Add a comment |

1 Answer 1