Making a formula to copy cells in a particula way

D

Dingerz

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
 
T

Teethless mama

Assuming your data in A2:A100

In B2: =INDEX($A$2:$A$100,ROW()/2)

copy down as far as needed
 
D

Dingerz

I have got it to work
=INDEX($A$346:$A$375,1/2)
But its not doing what i wanted and only copying 1 cell over and over again
 
M

Max

Try adapting TM's idea like this ..
Put in the start cell, eg in B346, then copy down:
=INDEX($A$346:$A$375,(ROWS($1:1)+1)/2)

Above tested ok here. Celebrate your success,
click the YES button below and in TM's response
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:68
xdemechanik
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy addition formula of non-consecutive horizontal cells 2
How to make repeating drop-down lists? 2
How to paste this down? 3
Merging from an Excel file with graphics 1
Formula's won't read copy / pasted data ? 2
Need Help with a VBA subroutine 0
Display bug in Word: tables disappearing on copy and paste of text with bullet points into table 2
Dealing with a Pivot Table (when I don't want to) 0

Top