Hi,
I have a list of data which i want to copy to a list in another sheet, but I want each row to duplicate 5 times before the next row is copied.
To be more specific:
In Sheet1, column A:
Apple
Banana
Orange
I want it to show like this in Sheet2:
Apple
Apple
Apple
Apple
Apple
Banana
Banana
Banana
Banana
Banana
Orange
Orange
Orange
Orange
Orange
Any suggestion of how I can do this with a macro?
Thanks in advance :-)
Bookmarks