Forum Discussion
Solved
unpivot only selected columns (date columns)
I have an Excel file with per machine in department the capacity in hours per month. This Excel file will be updated every month where the oldest month (on the left) disappears and a new month (on th...
a bit of google and found some useful video
https://www.youtube.com/watch?v=yJGdfh1Fo5E
= Table.Unpivot(#"Removed Other Columns", List.Select(Table.ColumnNames(#"Removed Other Columns"), each Text.Contains(_,"/",Comparer.OrdinalIgnoreCase)), "Attribute", "Value")changed a bit to my data and seems to work.
a bit of google and found some useful video
https://www.youtube.com/watch?v=yJGdfh1Fo5E
= Table.Unpivot(#"Removed Other Columns", List.Select(Table.ColumnNames(#"Removed Other Columns"), each Text.Contains(_,"/",Comparer.OrdinalIgnoreCase)), "Attribute", "Value")changed a bit to my data and seems to work.