Prevent my formula from jumping down

[Seminole1284]

First Time Poster so forgive the bad formatting. I am building a basic spreadsheet for our warehouses to use to print location labels. I data is in this format. In order to print labels, I need to stack the info on top of each other. When I do this and drag the formula down, it is jumping three locations and skipping rows. What can I use to be able to drag down a formula and it only jumps one row on the source data.

Source Data

Zone	Location	Location ID
A2	B2	C2
A3	B3	C3
A4	B4	C4

<tbody>
</tbody>

Label Page- I am stacking ZONE, LOCATION, and LOCATION ID on top of each other so it prints on a label stacked. When I drag it down, it currently skips three rows every time.

Currently Happening	What I need to achieve
=A2	=A2
=B2	=B2
=C2	=C2
=A5	=A3
=B5	=B3
=C5	=C3
=A8	=A4
=B8	=B4
=C8	=C4

<tbody>
</tbody>

Thank you in advance for your suggestions

 

[AhoyNC]

Welcome to the forum.
See attached link for formula used below. Just copy down as needed.

https://www.extendoffice.com/docume...anspose-multiple-columns-into-one-column.html

Excel Workbook
	A	B	C
1	Zone	Location	Location ID
2	A2	B2	C2
3	A3	B3	C3
4	A4	B4	C4
5
6
7	A2
8	B2
9	C2
10	A3
11	B3
12	C3
13	A4
14	B4
15	C4
Sheet

 

[Seminole1284]

Welcome to the forum.
See attached link for formula used below. Just copy down as needed.

https://www.extendoffice.com/docume...anspose-multiple-columns-into-one-column.html

	A	B	C
1	Zone	Location	Location ID
2	A2	B2	C2
3	A3	B3	C3
4	A4	B4	C4
5
6
7	A2
8	B2
9	C2
10	A3
11	B3
12	C3
13	A4
14	B4
15	C4

<colgroup><col style="width:30px; "><col style="width:51px;"><col style="width:74px;"><col style="width:80px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas

Cell Formula A7 =INDEX($A$2:$C$4,1+INT((ROW(A1)-1)/COLUMNS($A$1:$C$4)),MOD(ROW(A1)-1+COLUMNS($A$1:$C$4),COLUMNS($A$1:$C$4))+1) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

Thank you so much!

 

[AhoyNC]

You're welcome. Thanks for the feedback.