How to duplicate data in excel
 

I have a column of 1,000 part numbers. I need to have each pn listed 6 or 7
times in the same column. Is there any easy way to do this other than
copy-ing the whole list and then sorting?

How to duplicate data in excel
 

ASAP Utilities, an Excel Add-in available free at www.asap-utilities.com had
a couple of features that will allow you to add blank rows, and then
fill-down with the existing data.......

Vaya con Dios,
Chuck, CABGx3



"aet999" wrote:

I have a column of 1,000 part numbers. I need to have each pn listed 6 or 7
times in the same column. Is there any easy way to do this other than
copy-ing the whole list and then sorting?