Forum Discussion
Unpivoting Variable Number of Columns
Hello,
My dataset is an Excel file that is generated by a very inflexible program. In order to make functional tables, I need to unpivot the columns. My problem is that the number of columns in the Excel file changes every time the file is generated.
My data looks like this:
Date | Property | Product 1 | Product 2 | Product 3 .......
When I unpivot the Product columns the formula is:
= Table.Unpivot(#"Changed Type", {"Product 1", "Product 2", "Product 3", .... }
How can I change the function to unpivot all columns from column #3 up to (and including) the last column?
Thanks!
radomzal you can select the first two columns Date and Property, then Unpivot Other Columns.
It doesn't matter if there is 1 or 100 other columns, they will all get unpivoted.