Something like this?
(ooxml, embedded labels, table is Sheet1, filters(
Community_191166.qvw 144.2 K
Sorry for a late response. So I am not sure if there is anything about this in help, but I can tell you how I did this and how you can do other manipulation to your data within that place.:
Step1: When you on Edit Script window -> click on Table Files... (as you would usually do to bring in any Excel file)
Step2: Click next (after making any changes like Embedded Labels or Header Size or Tables) NOTE: DO NOT CLICK Finish
Step3: Click on Enable Transformation Step
Step4: Do you data manipulation as desired (I used Rotate tab to transpose your data)
I hope this will help.