How to duplicate data in excel

A

aet999

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?
 
C

CLR

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
 
Top