ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Need help copying cells into rows with spaces between (https://www.excelbanter.com/excel-discussion-misc-queries/196330-need-help-copying-cells-into-rows-spaces-between.html)

Doug Titus

Need help copying cells into rows with spaces between
 
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.


All times are GMT +1. The time now is 05:50 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com