Need help copying cells into rows with spaces between

D

Doug Titus

I'm trying to copy the contents from rows but need it to show
verticaly.

I need to reference cells by an increment of 1 but because of the
spaces between rows when I copy it increments by 4, or 5, or whatever
the distance is between them.

For example, I need lines 1, 5, 9... to show cells A1, A2, A3... and
not A1, A5, A9...

In very general terms I'm trying to get it in this format:

References A1
References B1
References C1
References D1
References A2
References B2
References C2
References D2

Thanks in advance for any help or ideas.
 

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

Top