You can separate Location column to columns for each location with the One to Many node. If this does not help enough, could you describe the pivot table you want to create in more detail? What are the group, pivot, and aggregation columns? Which aggregation method do you want to use?
I’m sorry I didn’t know that there were 3 places to take date from with the Pivoting Node. I was using the middle one. No wonder my data wasn’t displaying as I wanted it to.