pivot not working power query

[Anonymous]

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!

[Anonymous · Accepted solution]

Solution: I needed to refresh the view on the editor. A little box appeared above. I clicked this and it updated: