Brilliant as the Excel wrap row method 👍, thanks. This can also be done by unpivotting all columns: let Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content], #"Unpivoted Columns" = Table.UnpivotOtherColumns(Source, {}, "Attribute", "Value"), #"Removed Columns" = Table.FromRows(List.Split(Table.RemoveColumns(#"Unpivoted Columns",{"Attribute"})[Value],3), {"Date", "Product", "Quantity"}) in #"Removed Columns"
@howtolearnexcelКүн бұрын
Sure. Awesome idea! Clean and concise, I like it. Great job!