We have a database with a format similar to:

ID | Company Name | Visualappeal | Fitforpurpose | overall | etc
----------------------------------------------------------------------------
data | data , etc
data | data

This table is populated and contains hundreds of records? we now wish to
create another recordset based on the first? like this

Visualappeal: data
Fitforpurpose: data
Overall: data

Addittionally this needs to be filtered by the ID number so that only one lot
of results are returned

Is this possible in ASP/VBscript ? and if so how?

This is required purely to display data in a particular way? we do not need to
permanently create the recordset only temporarily.