Making a formula to copy cells in a particula way
Assuming your data in A2:A100
In B2: =INDEX($A$2:$A$100,ROW()/2)
copy down as far as needed
"Dingerz" wrote:
Hi I have hundreds of cells like this. All the way down a column
H8D-70GDT3322
H8D-70GDT3330
H8D-70GDT3331
H8D-70GDT3400
I want it to look like this (SEE BELOW). Effectivley copy each cell and
inserting it below, so that there are two of each data. Instead of me going
copy paste, copy paste etc. Is there a formula i can do to make it do what i
want? Even if it pastes it into another row that would be fine. Please help
H8D-70GDT3322
H8D-70GDT3322
H8D-70GDT3330
H8D-70GDT3330
H8D-70GDT3331
H8D-70GDT3331
H8D-70GDT3400
H8D-70GDT3400
|