Reverse-Crosstable Transformation?

[#1]

Hi Everyone,

I've got a data set, straight from a quirky source data system, that looks like the result of a crosstable transformation.... but shouldn't.  Basically, I have too many rows that should be columns -- so, what should be field names are appearing as row values in single a "Type" column.

If the number of Type values were small and static, I'd just do a series of LOAD * WHERE Type =1, 2, 3, etc... and concatenate the tables.  However...

What's the simplest way to perform a reverse-crosstable transformation?  Difficulty is there are also three preceding fields, including identity values, that shouldn't pivot.

Thanks,

DJ

[#2 · Accepted solution]

Nevermind, found it:

http://community.qlik.com/message/78337#78337

Alex's solution does exactly what I needed!