Transpose multiple columns to a single column

[cjkelly15]

Hello!

I am trying to figure out how to transpose multiple columns to one column.

I am building a forecast by customer SKU. From columns A-D, I have the SKU number, description, customer and customer number. For columns E-P, I have the months of the year. I have 300 skus, so 301 rows including the header.

Is there an easy excel function where I can take this horizontal forecast by month across columns and make it vertical? I would need to repeat the column A-D information 12x, one for each month, so 3600 rows. Column E would be the month, column F would be the Amount.

Is this possible?

 

[Fluff]

Hi & welcome to MrExcel.
How about like

Fluff.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1					Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
2	A1	B1	C1	D1	345	600	713	807	847	824	366	527	936	278	542	867
3	A2	B2	C2	D2	512	819	735	889	728	651	506	720	238	704	603	370
4	A3	B3	C3	D3	919	221	708	697	528	836	763	119	104	690	877	703
5	A4	B4	C4	D4	296	522	156	332	441	665	993	721	631	438	629	892
6	A5	B5	C5	D5	340	650	844	522	889	634	492	480	740	362	785	209
7	A6	B6	C6	D6	101	598	640	640	918	814	585	649	469	259	101	196
8	A7	B7	C7	D7	856	159	736	285	408	267	870	871	947	270	159	929
9	A8	B8	C8	D8	577	783	714	665	336	818	155	176	268	115	977	947
10	A9	B9	C9	D9	417	656	736	823	273	907	213	110	527	128	395	635
11
12	A1	B1	C1	D1	Jan	345
13	A1	B1	C1	D1	Feb	600
14	A1	B1	C1	D1	Mar	713
15	A1	B1	C1	D1	Apr	807
16	A1	B1	C1	D1	May	847
17	A1	B1	C1	D1	Jun	824
18	A1	B1	C1	D1	Jul	366
19	A1	B1	C1	D1	Aug	527
20	A1	B1	C1	D1	Sep	936
21	A1	B1	C1	D1	Oct	278
22	A1	B1	C1	D1	Nov	542
23	A1	B1	C1	D1	Dec	867
24	A2	B2	C2	D2	Jan	512
25	A2	B2	C2	D2	Feb	819
26	A2	B2	C2	D2	Mar	735
27	A2	B2	C2	D2	Apr	889
28	A2	B2	C2	D2	May	728
29	A2	B2	C2	D2	Jun	651
30	A2	B2	C2	D2	Jul	506
31	A2	B2	C2	D2	Aug	720
32	A2	B2	C2	D2	Sep	238
33	A2	B2	C2	D2	Oct	704
34	A2	B2	C2	D2	Nov	603
Main

Cell Formulas
Range	Formula
A12:F119	A12	=LET(s,SEQUENCE(,12),HSTACK(TOCOL(IF(s,A2:A10)),TOCOL(IF(s,B2:B10)),TOCOL(IF(s,C2:C10)),TOCOL(IF(s,D2:D10)),TOCOL(IF(SEQUENCE(9),E1:P1)),TOCOL(E2:P9)))
Dynamic array formulas.