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
[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Zone[/TD]
[TD]Location[/TD]
[TD]Location ID[/TD]
[/TR]
[TR]
[TD]A2[/TD]
[TD]B2[/TD]
[TD]C2[/TD]
[/TR]
[TR]
[TD]A3[/TD]
[TD]B3[/TD]
[TD]C3[/TD]
[/TR]
[TR]
[TD]A4[/TD]
[TD]B4[/TD]
[TD]C4[/TD]
[/TR]
</tbody>[/TABLE]







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.

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]Currently Happening[/TD]
[TD]What I need to achieve[/TD]
[/TR]
[TR]
[TD]=A2[/TD]
[TD]=A2[/TD]
[/TR]
[TR]
[TD]=B2[/TD]
[TD]=B2[/TD]
[/TR]
[TR]
[TD]=C2[/TD]
[TD]=C2[/TD]
[/TR]
[TR]
[TD]=A5[/TD]
[TD]=A3[/TD]
[/TR]
[TR]
[TD]=B5[/TD]
[TD]=B3[/TD]
[/TR]
[TR]
[TD]=C5[/TD]
[TD]=C3[/TD]
[/TR]
[TR]
[TD]=A8[/TD]
[TD]=A4[/TD]
[/TR]
[TR]
[TD]=B8[/TD]
[TD]=B4[/TD]
[/TR]
[TR]
[TD]=C8[/TD]
[TD]=C4[/TD]
[/TR]
</tbody>[/TABLE]

















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

<colgroup><col style="width:30px; "><col style="width:51px;"><col style="width:74px;"><col style="width:80px;"></colgroup><tbody>
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]1[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: center"]Zone[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: center"]Location[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=c0c0c0]#c0c0c0[/URL] , align: center"]Location ID[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]2[/TD]
[TD="align: center"]A2[/TD]
[TD="align: center"]B2[/TD]
[TD="align: center"]C2[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]3[/TD]
[TD="align: center"]A3[/TD]
[TD="align: center"]B3[/TD]
[TD="align: center"]C3[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]4[/TD]
[TD="align: center"]A4[/TD]
[TD="align: center"]B4[/TD]
[TD="align: center"]C4[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]5[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]6[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]7[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]A2[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]8[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]B2[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]9[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]C2[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]10[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]A3[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]11[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]B3[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]12[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]C3[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]13[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]A4[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]14[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]B4[/TD]

[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=cacaca]#cacaca[/URL] , align: center"]15[/TD]
[TD="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=ffff00]#ffff00[/URL] , align: center"]C4[/TD]

</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.