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.
|