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.