Forum Discussion
PowerQuery Year Month as headers / optimzation.
Hello, Maybe someone will have better solution to my issue ; I have table in excel which I'm pulling to PowerQuery as i need unpivot it and here I have 2 issues. 1. Part of the table...
1. You have the option to specify which columns to unpivot (Table.Unpivot) or which columns not to unpivot (Table.UnpivotOtherColumns). If you have a changing list of columns, then use unpivot other columns.
2. If the table is small enough to fit into memory, then applying Table.Buffer before unpivoting might speed things up.