View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
 
Posts: 10,124
Default how to duplicate rows?

Perhaps you could give an example???

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Marilyn" wrote in message
...
I really do not know how to explain this any easier that I did in my
initial
question, Perhaps there may be someone else who can answer this question,
I
have asked around within my own office and no one know how and no one
knows
how I could explain it any other way that would be simpler. Thanks the
responses that you tried to assist me with.
--
Marilyn - novice excel user.


"Don Guillett" wrote:

Either I need to learn how to guess better or you need to learn how to
explain better...
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Marilyn" wrote in message
...
Yes I need to repeat them. But keep them in the same order as they are
now
If
Bert came first, then Ernie€¦ I still need Bert first, (repeated 3
times)
and
then Ernie (3 times) and so on.
--
Marilyn - novice excel user.


"Don Guillett" wrote:

repeated ??

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Marilyn" wrote in message
...
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.