I am in Power Query. I want to pivot on a table with multiple values, and then take the max of each date. I go through:
- highlight my column
- transform tab--> pivot column
This results in only two columns being made, not all 6.
I tried manually adding the pivoted column names, but received an error:
Expression.SyntaxError: Invalid identifier.
Any suggestions are appreciated!
Solved! Go to Solution.