Can we extact some table data in excel and paste as transposed..??

Tue, 28 Dec 2010 10:16:07 GMT

Dear All,

I needs to extract some data from multiple tables on a sheet. Have an already buit macro to extracts the data in excel but I need the data as transposed. Means vertical in horizontal. Can anyone help..??

Can we extact some table data in excel and paste as transposed..??

jonathandienst — Tue, 28 Dec 2010 10:25:00 GMT

If you are using the File Wizard (the Table Files... button on load script edit page):

Click the "Enable Transformation Step" button on the second page of the wizard
Click the Rotate tab
Click the Transpose button.

You can also edit the load script directly, by adding a Transpose() statement to the filters(....), for example:

LOAD * FROM ......
(biff, embedded labels, table is Sheet1$, filters(Transpose()));

Hope that helps

Jonathan

topic Can we extact some table data in excel and paste as transposed..?? in QlikView

Can we extact some table data in excel and paste as transposed..??

Can we extact some table data in excel and paste as transposed..??