Forum Discussion
Solved
Data shaping problem
Hello, I wonder if anyone could advise on how best to start transforming this data for analysis/presentation in a pivot or matrix table: I am struggling with the category/value columns. Do I n...
Thanks to your link amitchandak I discovered it's pivot I need on category column, not unpivot! I am a step closer, thank you.
It's hard to tell what I am looking at. Seems like you would want to get rid of the blank Value rows? What are you trying to do with the data?