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