Duplicating rows multiple times in excel

Report
Posts
1
Registration date
Wednesday August 18, 2021
Status
Member
Last seen
August 18, 2021
-
Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
-
Hello,

I have a sheet with over 800 rows. I need to copy each row and insert/repeat each entry 4 times below the preceding row.

Example:

Before

name1
name2
name3


After

name1
name1
name1
name1
name2
name2
name2
name2
name3
name3
name3
name3

I'd appreciate it very much any help I can get with this.

Thank you.

1 reply

Posts
2819
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
October 25, 2021
487
Hi Ona,

This question has been asked before. In exactly the same wording and spacing.

Is this a homework assignment?

Best regards,
Trowa