How to transpose a resident table?

[#1]

PreTable:

Load a,

     b,

     c,

     d

FROM

[..\Data\foo.tabdel]

(txt, codepage is 1252, embedded labels, delimiter is '\t', msq)

where id = 2;

MyTable:

Load @1, @2

resident Aggregates (filters(Transpose));<-filters here gives syntax error

or any other way to achieve this?

[Gysbert_Wassenaar · Accepted solution]

Store the table into a qvd first. When loading the qvd file it is possible to add filters. You can use the File Wizard to create the load statement you need.