How do I create a specific number of duplicate records in Excel?

ailsybird · 2011-08-10 09:49:36

Is there a function for this? I'm editing an excel data file for statistical analysis in SPSS and I need to create specific numbers of duplicate records (each record corresponds to a row with 20 columns). In column A I have the number of duplicates I require - is there an easy function to do this or do I have to autofill…

10-08-2011 10:49AM

#1

ailsybird

Registered Users, Registered Users 2 Posts: 17 ✭

Join Date: September 2005

Posts: 7

Is there a function for this? I'm editing an excel data file for statistical analysis in SPSS and I need to create specific numbers of duplicate records (each record corresponds to a row with 20 columns). In column A I have the number of duplicates I require - is there an easy function to do this or do I have to autofill manually the numbers of records?

Thanks

0

Comments

#2 10-08-2011 11:38AM

MiCr0

Registered Users, Registered Users 2 Posts: 6,265 ✭✭✭

Join Date: February 1998

Posts: 5443

can't you just drag down from the bottom right corner for 20 lines and select copy cells?

0
#3 10-08-2011 12:29PM

fionny

Registered Users, Registered Users 2 Posts: 2,369 ✭✭✭

Join Date: June 2007

Posts: 2268

Could you do:

=$A$1

drag it down then if you change A1 all the others will change?

0