Forum Discussion
Unpivot issue
In the Query editor select the Category column, then under the Transform->Any Column sub menu click Pivot Column.
In the dialog box that appears change the Values Column to "Column1" from the drop down box
Click on advanced options and choose "don't aggrgate" from the Aggregate Value Function drop down box.
You should get the desired output.
Abhi
Hi,
I think I have solved your problem. Made a video, let me know if it works,
http://www.filedropper.com/groupfrommultipletextfiles
In the Query editor select the Category column, then under the Transform->Any Column sub menu click Pivot Column.
In the dialog box that appears change the Values Column to "Column1" from the drop down box
Click on advanced options and choose "don't aggrgate" from the Aggregate Value Function drop down box.
You should get the desired output.
Abhi
Thank you.
I was using the right click pop-up menu and I could not find the pivot functionality which I needed. However, you answer showed me that it is on the Transform menu and not in the pop-up menu.
Have edited my post to include the location of the Pivot Column option. Cheers.
