Duplicating content in cells below each cell

English
#1

I have a single column of cells (several thousand rows) that all contain different content, for example:

ABC123
DEF456
GHI789
JKL101
MNO112

What I am trying to do is insert a cell beneath each cell and then duplicate the content from the cell above, to achieve this:

ABC123
ABC123
DEF456
DEF456
GHI789
GHI789
JKL101
JKL101
MNO112
MNO112

Does anyone know if this is possible ?

Thanks!

#2

Copy the cells, paste the duplicates directly below and sort ascending.

2 Likes
#3

Good grief… that is so simple, argh… why didn’t I think of that?

#4

If do you need to keep the cell order, but cells are not sorted:
In an auxiliary column add 1, 2, etc., then follow @Villeroy advice, and finally sort by the numbers column.

2 Likes
#5

Thanks everyone for your help!

#6

(calc probably not being the right tool :expressionless: )
How to duplicate lines in Linux with keeping the original order? - Stack Overflow

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.