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

[Table="width:, class:head"]
[tr=bgcolor:#FFFFFF][td=bgcolor:#5B9BD5]Item[/td][td=bgcolor:#5B9BD5]Jan[/td][td=bgcolor:#5B9BD5]Feb[/td][td=bgcolor:#5B9BD5]Mar[/td][td][/td][td=bgcolor:#70AD47]Item[/td][td=bgcolor:#70AD47]Attribute[/td][td=bgcolor:#70AD47]Value[/td][/tr]

[tr=bgcolor:#FFFFFF][td=bgcolor:#DDEBF7]Item 1[/td][td=bgcolor:#DDEBF7]

2​

[/td][td=bgcolor:#DDEBF7]

3​

[/td][td=bgcolor:#DDEBF7]

5​

[/td][td][/td][td=bgcolor:#E2EFDA]Item 1[/td][td=bgcolor:#E2EFDA]Jan[/td][td=bgcolor:#E2EFDA]

2​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td]Item 2[/td][td]

1​

[/td][td]

4​

[/td][td]

2​

[/td][td][/td][td]Item 1[/td][td]Feb[/td][td]

3​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td][/td][td][/td][td=bgcolor:#E2EFDA]Item 1[/td][td=bgcolor:#E2EFDA]Mar[/td][td=bgcolor:#E2EFDA]

5​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td][/td][td][/td][td]Item 2[/td][td]Jan[/td][td]

1​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td][/td][td][/td][td=bgcolor:#E2EFDA]Item 2[/td][td=bgcolor:#E2EFDA]Feb[/td][td=bgcolor:#E2EFDA]

4​

[/td][/tr]

[tr=bgcolor:#FFFFFF][td][/td][td][/td][td][/td][td][/td][td][/td][td]Item 2[/td][td]Mar[/td][td]

2​

[/td][/tr]
[/table]

[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]