I have data with a level field with values 1 to 6. I want to list this data across. So I would like to build a temp table with Level1, level2, etc. So I would like to update from table1 that has the field Level containing a 1-6 and place the data related to that level into a corresponding column in the temp table. what would be the best technique to do this?