View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Marilyn Marilyn is offline
external usenet poster
 
Posts: 211
Default how to duplicate rows?

I would like to know how I can duplicate rows.
Lets say I have a thousand names in column A IE: Bert, Ernie, Bob, John,
Fred... and so on. I need to have Bert, Bert, Bert, Ernie, Ernie, Ernie, Bob,
Bob, Bob, John, John, John, Fred, Fred, Fred, Fred... although I need then 5
or 6 times repeated not just 3!
--
Marilyn - novice excel user.