Duplicating rows multiple times in excel

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
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
- 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.

1 reply

TrowaD
Posts
2886
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
June 27, 2022
512
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