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.