Excel 2007 : To repeat a particular pattern in excel

**noufelnbacker** · 07-06-2012, 11:57 PM

Hi,
I have an excel sheet having the values as given below

1 4 7 10
2 5 8 11
3 6 9 12

but i want it to be like

1
2
3
4
5
6
7
8
9
10
11
12

This is just an example.My actual requirement is 10000's of data like this.Is there is any formula to repeat this kind of pattern.

**dilipandey** · 07-07-2012, 01:44 AM

Hi noufelnbacker

Welcome to the forum.

Select any cell in your data and try below code :-

Please Login or Register  to view this content.

Regards,
DILIPandey

<click on below 'star' if this helps>

**noufelnbacker** · 07-08-2012, 11:42 AM

Hi dilipandey

Thanks for the help,however i am new into this macro field.I just created a new macro and copy pasted the code you gave and run the macro.but no result was coming.I am not sure whether i have done it the right way.Can u please explain regarding the execution of this macro?

**dilipandey** · 07-08-2012, 01:05 PM

Hi noufelnbacker,

Open your excel workbook, select any cell in your data, press Alt + F11, Insert -> Module and paste above code.
Now press Alt + F8 and choose the macro "copy" and click on Run.

Regards,
DILIPandey

<click on below 'star' if this helps>