Excel Power Query

[gheyman]

I have a table with numerious columns. Two of the columns are for quantities. There is a FromQty and a ToQty column. I Want to make transform the table so that the table has a seperate row for each the from and to.

So if I had a table something like this.

Part	FromQty	ToQty	UnitPrice
abcd	1	5	10.00
1234	10	25	8

Part	Qty	UnitPrice
abcd	1	10.00
abcd	5	10.00
1234	10	8.00
1234	25	8.00

How can I do this in Excel Power Query? Thanks!!

 

[alansidman]

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Part", type text}, {"FromQty", Int64.Type}, {"ToQty", Int64.Type}, {"UnitPrice", Int64.Type}}),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"Part", "UnitPrice"}, "Attribute", "Value"),
    #"Reordered Columns" = Table.ReorderColumns(#"Unpivoted Other Columns",{"Part", "Attribute", "Value", "UnitPrice"}),
    #"Renamed Columns" = Table.RenameColumns(#"Reordered Columns",{{"Value", "Qty"}}),
    #"Removed Columns" = Table.RemoveColumns(#"Renamed Columns",{"Attribute"})
in
    #"Removed Columns"

 

[gheyman]

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Changed Type" = Table.TransformColumnTypes(Source,{{"Part", type text}, {"FromQty", Int64.Type}, {"ToQty", Int64.Type}, {"UnitPrice", Int64.Type}}),
    #"Unpivoted Other Columns" = Table.UnpivotOtherColumns(#"Changed Type", {"Part", "UnitPrice"}, "Attribute", "Value"),
    #"Reordered Columns" = Table.ReorderColumns(#"Unpivoted Other Columns",{"Part", "Attribute", "Value", "UnitPrice"}),
    #"Renamed Columns" = Table.RenameColumns(#"Reordered Columns",{{"Value", "Qty"}}),
    #"Removed Columns" = Table.RemoveColumns(#"Renamed Columns",{"Attribute"})
in
    #"Removed Columns"

Thank you!