Thanks for everyones help.

I worked out a quick way to do it.

So effectively i numbered the columns 1-5 the opposite way round. Then in unpivoted the data making one column saying 1-5. So some of these would have had 3,4, and 5 for one salesid.

Then i addedin in a row_num using this column partitioned by the salesid - to turn 1,2 and 3.

THEN.... i pivot back using the row_num and bingo!!!!!

Thanks again all for the options - definitely got me thinking.