I know this question has been asked before but it has been a few years.
Others have written about it too.
Everything I've read suggests you have to know the values of the column (in long format) whose values become columns in wide format. I have not seen a method for pivoting without knowing all the possible values ahead of time.
So...is there a way to pivot without explicitly naming all the new columns?
Thanks.
