Splitting Row Data

[5h1v]

Hey,

Currently this pulls the data in one row

[COLOR=#333333][FONT=Tahoma][I]
Ary = Application.Index(wb2.Sheets(4).Range("A8:U17").Value, Evaluate("row(1:10)"), Array(1, 3, 4, 7, 13, 14, 15, 16, 17, 18, 19, 20, 21)) Ws.Range("A" & L).Resize(10).Value = wb2.Sheets(4).Range("D3").Value
Ws.Range("B" & L).Resize(10).Value = wb2.Sheets(4).Range("G3").Value
Ws.Range("C" & L).Resize(10).Value = wb2.Sheets(4).Range("A6").Value
Ws.Range("D" & L).Resize(10, 13).Value = Ary
L = L + 10
[/I][/FONT]
[/COLOR]

This pulls data into rows A-N
I want all the data repeated on rows A-H then what is in I on the first row, the second would be A-H + J then A-H +K all the way to A-H + N.

I hope that makes sense.

Is there an easy way I could do this?

 

[Peter_SSs]

I hope that makes sense.

It doesn't to me and given that your thread has been looked at over 50 times I suspect others are finding the same.
Perhaps you could try again to spell it out more clearly and also give a small set of dummy sample data and expected results?

 

[5h1v]

Thanks I will try;

[TABLE]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH][/TH]
[TH]A[/TH]
[TH]B[/TH]
[TH]C[/TH]
[TH]D[/TH]
[TH]E[/TH]
[TH]F[/TH]
[TH]G[/TH]
[TH]H[/TH]
[TH]I[/TH]
[TH]J[/TH]
[TH]K[/TH]
[TH]L[/TH]
[TH]M[/TH]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD]Item No.[/TD]
[TD]ITEM NAME[/TD]
[TD]Type[/TD]
[TD]SRN[/TD]
[TD]Supplier[/TD]
[TD]Supplier Code[/TD]
[TD]Placement[/TD]
[TD]COLOURWAY 1[/TD]
[TD]COLOURWAY 2[/TD]
[TD]COLOURWAY 3[/TD]
[TD]COLOURWAY 4[/TD]
[TD]COLOURWAY 5[/TD]
[TD]COLOURWAY 6[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: right"]3922[/TD]
[TD]F Legging[/TD]
[TD]FABRICS[/TD]
[TD="align: right"]1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]BLACK[/TD]
[TD]NAVY[/TD]
[TD]JADE GREEN[/TD]
[TD]ROSE TAUPE[/TD]
[TD]RASPBERRY RED[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: right"]3922[/TD]
[TD]F Legging[/TD]
[TD]FABRICS[/TD]
[TD="align: right"]1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]BLACK[/TD]
[TD]BLACK STANDARD[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: right"]3922[/TD]
[TD]F Legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD="align: right"]2168[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: right"]3922[/TD]
[TD]F Legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD="align: right"]2618[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: right"]3933[/TD]
[TD]Legging[/TD]
[TD]FABRICS[/TD]
[TD="align: right"]1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]BLACK[/TD]
[TD]ASH TEAL[/TD]
[TD]BLUSH PINK[/TD]
[TD]SMOKEY GREY[/TD]
[TD]CITRUS ORANGE[/TD]
[TD]OBSIDIAN GREEN[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: right"]3933[/TD]
[TD]Legging[/TD]
[TD]FABRICS[/TD]
[TD="align: right"]1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]BLACK[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: right"]3933[/TD]
[TD]Legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD="align: right"]2168[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND & FRONT WAISTBAND LHSAW[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="align: right"]3924[/TD]
[TD]C legging[/TD]
[TD]FABRICS[/TD]
[TD="align: right"]1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]BLACK[/TD]
[TD]BURGUNDY RED[/TD]
[TD]SPRINT BLUE[/TD]
[TD]ROSE TAUPE[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: right"]3924[/TD]
[TD]C legging[/TD]
[TD]FABRICS[/TD]
[TD="align: right"]1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]BLACK[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD="align: right"]3924[/TD]
[TD]C legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD="align: right"]2168[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND & FRONT WAISTBAND LHSAW[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]12[/TD]
[TD="align: right"]3926[/TD]
[TD]F Short[/TD]
[TD]FABRICS[/TD]
[TD="align: right"]1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]BLACK[/TD]
[TD]BLUSH PINK[/TD]
[TD]CITRUS ORANGE[/TD]
[TD]SMOKEY GREY[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]13[/TD]
[TD="align: right"]3926[/TD]
[TD]F Short[/TD]
[TD]FABRICS[/TD]
[TD="align: right"]1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]BLACK[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]14[/TD]
[TD="align: right"]3926[/TD]
[TD]F Short[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD="align: right"]2168[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT AND BACK WAISTABND[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]15[/TD]
[TD="align: right"]3928[/TD]
[TD]Short[/TD]
[TD]FABRICS[/TD]
[TD="align: right"]1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]BLACK[/TD]
[TD]RASPBERRY RED[/TD]
[TD]SPRINT BLUE[/TD]
[TD]OBSIDIAN GREEN[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]16[/TD]
[TD="align: right"]3928[/TD]
[TD]Short[/TD]
[TD]FABRICS[/TD]
[TD="align: right"]1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]17[/TD]
[TD="align: right"]3928[/TD]
[TD]Short[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD="align: right"]2168[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT WAISTBAND AND BACK WAISTBAND[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD]WHITE[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]
[CENTER]
[/CENTER]


This is the data that I have, I want to then split this out by colourway so that the columns A-G are repeated for each supplier code (F) and then the colour is added at the end H-M

I hope that makes more sense.

 

[Peter_SSs]

So what would the expected results look like? I expect the first 10-12 rows should do to give the idea?

 

[5h1v]

Sure, the above should look like this;

[TABLE]
<colgroup><col><col><col><col><col><col><col><col><col></colgroup><thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH][/TH]
[TH]A[/TH]
[TH]B[/TH]
[TH]C[/TH]
[TH]D[/TH]
[TH]E[/TH]
[TH]F[/TH]
[TH]G[/TH]
[TH]H[/TH]
[/TR]
</thead><tbody>[TR]
[TD="align: center"]1[/TD]
[TD]Item No.[/TD]
[TD]ITEM NAME[/TD]
[TD]Type[/TD]
[TD]SRN[/TD]
[TD]Supplier[/TD]
[TD]Supplier Code[/TD]
[TD]Placement[/TD]
[TD]Colourway[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]BLACK[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]NAVY[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]JADE GREEN[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]ROSE TAUPE[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]RASPBERRY RED[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]BLACK[/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]BLACK STANDARD[/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]12[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]13[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]14[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]15[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]16[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]17[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]18[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]19[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]20[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]21[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]22[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]23[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]24[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]25[/TD]
[TD="align: right"]3922[/TD]
[TD]F legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]26[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]BLACK[/TD]
[/TR]
[TR]
[TD="align: center"]27[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]ASH TEAL[/TD]
[/TR]
[TR]
[TD="align: center"]28[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]BLUSH PINK[/TD]
[/TR]
[TR]
[TD="align: center"]29[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]SMOKEY GREY[/TD]
[/TR]
[TR]
[TD="align: center"]30[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]CITRUS ORANGE[/TD]
[/TR]
[TR]
[TD="align: center"]31[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]OBSIDIAN GREEN[/TD]
[/TR]
[TR]
[TD="align: center"]32[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]BLACK[/TD]
[/TR]
[TR]
[TD="align: center"]33[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]34[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]35[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]36[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]37[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]38[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND & FRONT WAISTBAND LHSAW[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]39[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND & FRONT WAISTBAND LHSAW[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]40[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND & FRONT WAISTBAND LHSAW[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]41[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND & FRONT WAISTBAND LHSAW[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]42[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND & FRONT WAISTBAND LHSAW[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]43[/TD]
[TD="align: right"]3923[/TD]
[TD]legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND & FRONT WAISTBAND LHSAW[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]44[/TD]
[TD="align: right"]3924[/TD]
[TD]C Legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]BLACK[/TD]
[/TR]
[TR]
[TD="align: center"]45[/TD]
[TD="align: right"]3924[/TD]
[TD]C Legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]BURGUNDY RED[/TD]
[/TR]
[TR]
[TD="align: center"]46[/TD]
[TD="align: right"]3924[/TD]
[TD]C Legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]SPRINT BLUE[/TD]
[/TR]
[TR]
[TD="align: center"]47[/TD]
[TD="align: right"]3924[/TD]
[TD]C Legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]ROSE TAUPE[/TD]
[/TR]
[TR]
[TD="align: center"]48[/TD]
[TD="align: right"]3924[/TD]
[TD]C Legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]BLACK[/TD]
[/TR]
[TR]
[TD="align: center"]49[/TD]
[TD="align: right"]3924[/TD]
[TD]C Legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]50[/TD]
[TD="align: right"]3924[/TD]
[TD]C Legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]51[/TD]
[TD="align: right"]3924[/TD]
[TD]C Legging[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]52[/TD]
[TD="align: right"]3924[/TD]
[TD]C Legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND & FRONT WAISTBAND LHSAW[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]53[/TD]
[TD="align: right"]3924[/TD]
[TD]C Legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND & FRONT WAISTBAND LHSAW[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]54[/TD]
[TD="align: right"]3924[/TD]
[TD]C Legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND & FRONT WAISTBAND LHSAW[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]55[/TD]
[TD="align: right"]3924[/TD]
[TD]C Legging[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]BACK WAISTBAND & FRONT WAISTBAND LHSAW[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]56[/TD]
[TD="align: right"]3926[/TD]
[TD]F Short[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]BLACK[/TD]
[/TR]
[TR]
[TD="align: center"]57[/TD]
[TD="align: right"]3926[/TD]
[TD]F Short[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]BLUSH PINK[/TD]
[/TR]
[TR]
[TD="align: center"]58[/TD]
[TD="align: right"]3926[/TD]
[TD]F Short[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]CITRUS ORANGE[/TD]
[/TR]
[TR]
[TD="align: center"]59[/TD]
[TD="align: right"]3926[/TD]
[TD]F Short[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]SMOKEY GREY[/TD]
[/TR]
[TR]
[TD="align: center"]60[/TD]
[TD="align: right"]3926[/TD]
[TD]F Short[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]BLACK[/TD]
[/TR]
[TR]
[TD="align: center"]61[/TD]
[TD="align: right"]3926[/TD]
[TD]F Short[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]62[/TD]
[TD="align: right"]3926[/TD]
[TD]F Short[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]63[/TD]
[TD="align: right"]3926[/TD]
[TD]F Short[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]64[/TD]
[TD="align: right"]3926[/TD]
[TD]F Short[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT AND BACK WAISTABND[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]65[/TD]
[TD="align: right"]3926[/TD]
[TD]F Short[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT AND BACK WAISTABND[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]66[/TD]
[TD="align: right"]3926[/TD]
[TD]F Short[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT AND BACK WAISTABND[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]67[/TD]
[TD="align: right"]3926[/TD]
[TD]F Short[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT AND BACK WAISTABND[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]68[/TD]
[TD="align: right"]3928[/TD]
[TD]Short[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]BLACK[/TD]
[/TR]
[TR]
[TD="align: center"]69[/TD]
[TD="align: right"]3928[/TD]
[TD]Short[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]RASPBERRY RED[/TD]
[/TR]
[TR]
[TD="align: center"]70[/TD]
[TD="align: right"]3928[/TD]
[TD]Short[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]SPRINT BLUE[/TD]
[/TR]
[TR]
[TD="align: center"]71[/TD]
[TD="align: right"]3928[/TD]
[TD]Short[/TD]
[TD]FABRICS[/TD]
[TD]SRN1877[/TD]
[TD]Supplier 1[/TD]
[TD]KS0151CM[/TD]
[TD]ALL OVER MAIN BODY[/TD]
[TD]OBSIDIAN GREEN[/TD]
[/TR]
[TR]
[TD="align: center"]72[/TD]
[TD="align: right"]3928[/TD]
[TD]Short[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]73[/TD]
[TD="align: right"]3928[/TD]
[TD]Short[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]74[/TD]
[TD="align: right"]3928[/TD]
[TD]Short[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]75[/TD]
[TD="align: right"]3928[/TD]
[TD]Short[/TD]
[TD]FABRICS[/TD]
[TD]SRN1031[/TD]
[TD]Supplier 1[/TD]
[TD]1S0086LN[/TD]
[TD]FRONT WAISTBAND (INTERNAL)[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]76[/TD]
[TD="align: right"]3928[/TD]
[TD]Short[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT WAISTBAND AND BACK WAISTBAND[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]77[/TD]
[TD="align: right"]3928[/TD]
[TD]Short[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT WAISTBAND AND BACK WAISTBAND[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]78[/TD]
[TD="align: right"]3928[/TD]
[TD]Short[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT WAISTBAND AND BACK WAISTBAND[/TD]
[TD]WHITE[/TD]
[/TR]
[TR]
[TD="align: center"]79[/TD]
[TD="align: right"]3928[/TD]
[TD]Short[/TD]
[TD]EMBELLISHMENT (LOGOS, SCREEN PRINTS, EMBROIDERIES, JACQUARD)[/TD]
[TD]SRN2168-M[/TD]
[TD]Supplier 2[/TD]
[TD]SRN2168-M[/TD]
[TD]FRONT WAISTBAND AND BACK WAISTBAND[/TD]
[TD]WHITE[/TD]
[/TR]
</tbody>[/TABLE]
[CENTER][COLOR=#161120][B]
[/B][/COLOR][/CENTER][TABLE="width: 85%"]
<tbody></tbody>[/TABLE]



Thanks for the help

 

[Peter_SSs]

There seems to be an issue with the results in column D, both about the values returned
a) eg the last row of your results says SRN2168-M but that looks like it actually comes from column F
b) The results are prefixed with SRN. Is that required? I haven't done so in this code but it could be done if required.

This code puts the results below the original data.

Test in a copy of your workbook.

Sub RearrangeData()
  Dim a As Variant, b As Variant
  Dim i As Long, j As Long, k As Long, c As Long, uba2 As Long
  
  a = Range("A2", Range("A" & Rows.Count).End(xlUp)).Resize(, Cells(1, Columns.Count).End(xlToLeft).Column).Value
  uba2 = UBound(a, 2)
  ReDim b(1 To UBound(a) * (uba2 - 7), 1 To 8)
  For i = 1 To UBound(a)
    For j = 8 To uba2
      If Len(a(i, j)) > 0 Then
        k = k + 1
        For c = 1 To 7
          b(k, c) = a(i, c)
        Next c
        b(k, 8) = a(i, j)
      End If
    Next j
  Next i
  With Range("A" & Rows.Count).End(xlUp).Offset(3).Resize(, 8)
    .Value = Range("A1:H1").Value
    .Cells(1, 8).Value = "Colourway"
    .Offset(1).Resize(k).Value = b
  End With
End Sub

 

[5h1v]

That worked perfectly, thank you so much

 

[Peter_SSs]

That worked perfectly, thank you so much

You're welcome. Thanks for the confirmation.

 

[5h1v]

If i wanted to expand this so that I could include up to column P, how would I do that?