Hi All
I am stuck with a problem of looping sheets and workbooks and transposing the data in them. Just cannot find a solution.
From my previous posts and checking out community I could manage to loop sheets and workbooks in one code and Transpose the values by writing another code. When I try to combine it I fail.
Please see attached .qvw and supporting data and also the edit script for reference.. Also attached a workbook with an output I want it to look like.
Data attached is just a sample. Have about 30 workbooks and each workbook has multiple sheets but the data structure is the same in all of them (same as the one attached).
I would be extremely grateful if someone can help me with this please.
