Excel - Change Row based values to column based by formula

[Bilingual]

Hi, i have data in a row formula:

Month	Product 1	Product 2	Product 3
January	122	344	4555
Februar	556	555	655

I need to make a new table where the row is changed to column, i have tried with INDEX MATCH to no avail, i need to make it Lookup both in Rows and Columns in order to make it work - can you please help?

Month	Product	Value
January	Product 1	122
January	Product 2	344
January	Product 3	655
February	Product 1	556
February	Product 2	555
February	Product 3	655

 

[Kerryx]

Use Power query fast and simple

 

[Kerryx]

Similar to what was done here
switch around

 

[Fluff]

For 365 how about

Fluff.xlsm
	A	B	C	D	E	F	G	H	I
1	Month	Product 1	Product 2	Product 3			January	Product 1	122
2	January	122	344	4555			January	Product 2	344
3	Februar	556	555	655			January	Product 3	4555
4							Februar	Product 1	556
5							Februar	Product 2	555
6							Februar	Product 3	655
7
Report

Cell Formulas
Range	Formula
G1:I6	G1	=LET(Mnth,A2:A3,Prd,B1:D1,Data,B2:D3,c,COLUMNS(Data),s,SEQUENCE(c*ROWS(Data),,0),CHOOSE({1,2,3},INDEX(Mnth,INT(s/c)+1),INDEX(Prd,MOD(s,c)+1),INDEX(Data,INT(s/c)+1,MOD(s,c)+1)))
Dynamic array formulas.