Reformat Table

[Banditeb]

I have a sheet that is formatted similar to this...

Jan Feb Mar
Item 1 2 3 5
Item 2 1 4 2


I need it to format like this for an upload...

Item 1 Jan 2
Item 1 Feb 3
Item 1 Mar 5
Item 2 Jan 1
Item 2 Feb 4
Item 2 Mar 2

I know there is away wit a 2 step pivot table but can not figure it out.

Thanks

 

[sandy666]

try with PowerQuery

Item	Jan	Feb	Mar		Item	Attribute	Value
Item 1	2​	3​	5​		Item 1	Jan	2​
Item 2	1​	4​	2​		Item 1	Feb	3​
					Item 1	Mar	5​
					Item 2	Jan	1​
					Item 2	Feb	4​
					Item 2	Mar	2​

[SIZE=1]let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Item", type text}, {"Jan", Int64.Type}, {"Feb", Int64.Type}, {"Mar", Int64.Type}}),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"Item"}, "Attribute", "Value")
in
    #"Unpivoted Other Columns"[/SIZE]