Easiest way is for your mate to add you as a named driver on his policy. Alternatively he could cancel his policy and you take a new one out, then cancel it within the 14 day cooling off period.
I used Aviva last year to insure the FiL's car for a day to take it to the BiL's 300 mile away. We were swopping cars (long story). Think it cost about £24.