Previous Topic Next Topic

Duplicating rows multiple times in excel

Closed
Ona_4053 Posts 1 Registration date Wednesday August 18, 2021 Status Member Last seen August 18, 2021 - Aug 18, 2021 at 06:52 PM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 - Aug 23, 2021 at 12:05 PM
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.
Related:

1 reply

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen January 16, 2023 545
Aug 23, 2021 at 12:05 PM
Hi Ona,

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

Is this a homework assignment?

Best regards,
Trowa
0