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 December 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.
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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

Similar discussions

You have guessed the code too many times. Contact support
nanosama95 -
Komu -

4 responses
How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Date formatting in dd/mm/yyyy
nisha -
appu -

11 responses