Thanks Rickard Max may not work as not all the data is numerical. However I will give the
contrib/cross-tab a go!
It will work as long as you only have one non-null value per grouped field (which you did in your example).
| symbol | linktype -------------------+------+------+-------------------+-----------+---- -------------------+------+------+-------------------+-----------+---- -------------------+------+------+-------------------+-----------+-- 100473 | 93 | | | | 100473 | | 77 | | | 100473 | | | text1 | |
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])