vba: Horizontal List to Vertical with condition

[gtd526]

Hello, Im looking to convert a Horizontal list to a Vertical list with new a column for each "Week" in list.
Here is the data that needs to be converted:

NFL.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ	AK	AL	AM	AN	AO	AP	AQ	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BB	BC	BD	BE	BF	BG	BH	BI	BJ	BK	BL	BM	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB	CC	CD	CE	CF	CG	CH	CI	CJ	CK	CL	CM	CN	CO	CP	CQ	CR	CS	CT	CU	CV	CW	CX	CY	CZ	DA	DB	DC	DD	DE	DF	DG	DH	DI	DJ	DK	DL	DM	DN	DO	DP	DQ	DR	DS	DT	DU	DV	DW	DX	DY	DZ	EA	EB	EC	ED	EE	EF	EG	EH	EI	EJ	EK	EL	EM	EN	EO	EP	EQ	ER	ES	ET	EU	EV	EW	EX	EY	EZ	FA	FB	FC	FD	FE	FF	FG	FH	FI	FJ	FK	FL	FM	FN	FO	FP	FQ	FR	FS	FT	FU	FV	FW	FX	FY	FZ	GA	GB	GC	GD	GE	GF	GG	GH	GI	GJ	GK	GL	GM	GN	GO	GP	GQ	GR	GS	GT	GU	GV	GW	GX	GY	GZ	HA	HB	HC	HD	HE	HF	HG	HH	HI	HJ	HK	HL	HM	HN	HO	HP	HQ	HR	HS	HT	HU	HV	HW	HX	HY	HZ	IA	IB	IC	ID	IE	IF	IG	IH	II	IJ	IK	IL	IM	IN	IO	IP	IQ	IR	IS	IT	IU	IV	IW	IX	IY	IZ	JA	JB	JC	JD	JE	JF	JG	JH	JI	JJ	JK	JL	JM
1	Week	HOU	SEA	CLE	NYJ	OAK	CHI	IND	GB	MIA	PHI	LAC	TB	ARZ	DAL	PIT	TEN	Week	CIN	NYG	ATL	DET	MIN	BUF	SF	LAR	DEN	CAR	JAX	WAS	BAL	KC	NE	NO	Week	MIA	CHI	LAR	WAS	TEN	OAK	SF	CIN	HOU	NYJ	CAR	DET	TB	DAL	GB	KC	Week	DEN	ARZ	IND	JAX	CLE	NO	MIN	SEA	LAC	PIT	BAL	NYG	NE	BUF	PHI	ATL	Week	TB	CAR	CIN	JAX	OAK	DEN	ARZ	PHI	BUF	LAR	MIA	IND	NYG	MIN	LAC	Week	KC	CIN	DET	ATL	WAS	BAL	CLE	HOU	MIA	NYJ	GB	LAR	ARZ	Week	NYG	DET	PIT	NO	CLE	GB	LAC	CAR	BUF	DAL	SEA	KC	SF	TB	CHI	Week	ATL	NE	TEN	OAK	IND	MIN	NYJ	LAR	JAX	NO	SF	DAL	TB	Week	GB	DEN	SEA	BAL	HOU	CAR	DET	CHI	NYG	OAK	MIA	PIT	NO	NE	Week	IND	TB	HOU	WAS	JAX	PHI	CIN	BUF	DEN	NYJ	SEA	SF	BAL	MIN	Week	ARZ	TEN	DET	PHI	NE	GB	PIT	ATL	CIN	LAC	DAL	KC	LAR	Week	HOU	WAS	BAL	OAK	LAC	NYG	TEN	CLE	CAR	ARZ	MIA	NO	SF	KC	CHI	SEA	Week	DAL	NO	DET	IND	CIN	JAX	OAK	WAS	CLE	LAR	NYG	PHI	NE	DEN	BUF	Week	NE	DEN	HOU	DAL	GB	TEN	KC	ARZ	MIN	IND	NYJ	ATL	NO	WAS	PIT	BAL	Week	LAC	BUF	CAR	HOU	NYJ	DET	TB	JAX	NE	CHI	CLE	SEA	PHI	KC	SF	PIT	Week	MIN	SF	TB	MIA	DEN	CLE	NYG	CIN	CHI	ATL	IND	CAR	LAR	PHI	TEN	BUF	Week	MIA	NO	GB	BAL	PIT	MIN	TEN	JAX	LAC	NYJ	DAL	WAS	ATL	OAK	ARZ	SEA
2	1	KC	ATL	BAL	BUF	CAR	DET	JAX	MIN	NE	WAS	CIN	NO	SF	LAR	NYG	DEN	2	CLE	CHI	DAL	GB	IND	MIA	NYJ	PHI	PIT	TB	TEN	ARZ	HOU	LAC	SEA	OAK	3	JAX	ATL	BUF	CLE	MIN	NE	NYG	PHI	PIT	IND	LAC	ARZ	DEN	SEA	NO	BAL	4	NYJ	CAR	CHI	CIN	DAL	DET	HOU	MIA	TB	TEN	WAS	LAR	KC	OAK	SF	GB	5	CHI	ATL	BAL	HOU	KC	NE	NYJ	PIT	TEN	WAS	SF	CLE	DAL	SEA	NO	6	BUF	IND	JAX	MIN	NYG	PHI	PIT	TEN	DEN	LAC	TB	SF	DAL	7	PHI	ATL	BAL	CAR	CIN	HOU	MIA	NO	NYJ	WAS	ARZ	DEN	NE	OAK	LAR	8	CAR	BUF	CIN	CLE	DET	GB	KC	MIA	LAC	CHI	SEA	PHI	NYG	9	SF	ATL	BUF	IND	JAX	KC	MIN	TEN	WAS	LAC	ARZ	DAL	TB	NYJ	10	TEN	CAR	CLE	DET	GB	NYG	PIT	ARZ	OAK	MIA	LAR	NO	NE	CHI	11	SEA	BAL	CAR	CLE	HOU	IND	JAX	NO	WAS	DEN	MIN	OAK	TB	12	DET	DAL	PIT	ATL	BUF	CIN	IND	JAX	MIN	NE	NYJ	DEN	LAR	TB	GB	PHI	13	BAL	ATL	CHI	HOU	MIA	MIN	NYJ	PIT	TEN	ARZ	SEA	GB	LAC	KC	SF	14	LAR	CAR	CHI	CIN	DET	JAX	MIA	NYG	TB	OAK	SEA	LAC	PHI	SF	BUF	CLE	15	OAK	DEN	GB	IND	LAR	TEN	ATL	BAL	MIA	MIN	NYG	WAS	ARZ	NO	DAL	CIN	16	NO	ARZ	DET	OAK	LAC	NYJ	BAL	HOU	JAX	KC	PIT	WAS	SEA	DAL	GB	NE	17	BUF	CAR	CHI	CIN	CLE	DET	HOU	IND	KC	NE	NYG	PHI	TB	DEN	LAR	SF
Raw

Each Column starts a new 'Week'.
The text order for each Column:
Column 1 = A1,A2,B1,B2,C1,C2,D1,D1,D2,etc
Column 2 = R1,R2,S1,S2,T1,T2,U1,U2,V1,V2,etc
Example of possible outcome:

NFL.xlsm
	A	B	C
1	Week	Week	Week
2	1	2	3
3	HOU	CIN	MIA
4	KC	CLE	JAX
5	SEA	NYG	CHI
6	ATL	CHI	ATL
7	CLE	ATL	LAR
8	BAL	DAL	BUF
Sheet1

thanks for your help!

 

[Fluff]

Will each week always be 17 columns and 2 rows?

 

[Fluff]

Duplicate Horizontal to Vertical

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).