I have a table schema such like ID | Col1 | Col2 | Col3 | Value 1 a null null X 2 null a null Y 3 null null a Z 4 b null null A 5 null b null B 6 null null b C
Right now these are in the same table (they may be different tables in the near future, but I don't think that impacts this discussion) I want to "PIVOT" this data such that: A | Value | Value | Value a X Y Z b A B C Searching on the internet says this can be done in SQLite using CASE statements? But what happens I don't know the row id values (i.e. a, b, etc)? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
