Copy Block of Values Repeating 1 Column's Value

**sae2003us** · 12-18-2012, 11:47 AM

Hi,

I have the following table:

ID Date
1 01/10/12
1 02/10/12
1 03/10/12
1 04/10/12
2 01/10/12
2 02/10/12
2 03/10/12
2 04/10/12

The goal is the copy this down to an ID of 250 repeating those 4 dates.

The issue is as the ID's go up a rather high number I don't really want to copy and paste 200+ times.

I've tried highlighting that whole chunk then dragging down however the ID values become decimal values.

Could anyone help with a more elegant/built in/efficent solution.

Thanks.

**RHCPgergo** · 12-18-2012, 12:05 PM

Hi,

how about something like this.

edit: obviously type the proper dates to the cells where date1, date2, etc. are located.

**Ghozi Alkatiri** · 12-18-2012, 12:18 PM

if your data constantly with that date and serial Id

first formula at B2 for serial repeat Id
=TRUNC((ROWS(A$2:A2)-1)/4)+1

and for serial date write manual date at B2:B5

first formula to repeat serial date like above at B6:

=INDEX($B$2:$B$5;MOD(ROWS(A$2:A6)-1;4)+1)

copy down till you want to finish