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

[#1]

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..??

[jonathandienst · Accepted solution]

Hi

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